Only evaluate today() once or freeze date cell once populated?

Jamison

I would like to automatically record the date a project is marked complete. I have a dropdown column with "complete" as an option. I have a "date closed" column that return today's date if the dropdown column value is "closed".

 

Of course, the next day, "today()" wil evaluate to the current day and not the day it was initially marked closed. I did see the sugestion of using the modified date, but that is not ideal.

 

Is there an easy way to do this that i am missing? Or is there a way to deactivate a formula or overwrite a formula if a condition is met?

 

Thanks.

Kennedy Stomps

Hi Jamison-- At this point, the TODAY() function will change to reflect the current date and it isn't possible to prevent this date from changing. I know that some users have requested a way to capture the current date and not have it change daily, and I can add your vote for this to our enhancement request list. In the meantime, you'd either need to manually enter the date or pull the date from the Modified (Date) system column. 

Jamison

OK - Thanks. I just wanted to make sure I am not missing something.