Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Only evaluate today() once or freeze date cell once populated?
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.
Comments
-
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.
-
OK - Thanks. I just wanted to make sure I am not missing something.
