I want date to = the day the status = completed. How to change a field ""Completed Date"" to the date of when a multiple choice field, containing ""Completed"" is selected?

Question

Is there a way to do this without using form rules? I want the 'completed date' to = the day the status is changed to 'completed'.

I just used Date Modified, ToDate([Date Modified]), for now, but I was wondering if there was a way to do this for when the multiple choice option 'Completed' is chosen so the completed date is changed to that date.

DavidHawe · Answer

If the Status field is not logged, you could do this:

If(
[Status]="Completed",ToDate([Date Modified])
)

The danger is if the record is modified again on a later date, the later date will show.

If the Status field is a logged field, you can use Left and Right statements to isolate the date in the text of the logged field.

Sign up

Login to the community