Forum Discussion
How to calculate a date and maintain the record
I have a choice field in a sharepoint list. The choices include Acknowledged & Resolved. I'd like to have a date record registered when we change the choice to either of those. I have been using...
em_amdahl your formula should be =IF(OR([Issue Status]="Acknowledged", [Issue Status]="Resolved"), TODAY(),"")
As a calculated column doesn't update dynamically when the date changes it will maintain the date when the choice column was changed to Acknowledged or Resolved.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
- Is there a way to restrict it from pulling a date when they select "resolved"?
I have to pull a date field for when it is resolved and when it is acknowledged.em_amdahl sorry, I don't understand what you mean by pulling a date.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
