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?

Jamison ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

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?





  • Kennedy Stomps
    Kennedy Stomps Employee
    edited 08/24/16

    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
    Jamison ✭✭✭✭✭
    edited 08/24/16

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

This discussion has been closed.