Forum Discussion

Qrew Member

9 years ago

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?

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 ...

Forms

Relationships

roles and permissions

MeredithMoore1

Qrew Cadet

8 years ago

ok but what if there is another condition... (I have no idea why this isn't working.)

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

Forum Discussion

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?

Related Content

How to Completely Prevent "More - Copy this record"

How do I make a formula date field called ""Completion Date"" that captures the date when a multiple choice field called ""Status"" is set to a particular value like ""Complete""?

Generate a "% Complete" tally

How do I make this work? If( IsNull([Date Complete]) and [Status]=""Completed"",ToDate([Date Modified]), [Date Complete])

If I have a Projects table and a Tasks table where each Project record has many Task records how do I automatically indicate that the Project is completed when the ""Status"" field in all the related tasks are marked ""Completed""?