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.

Static Date/Time Time Stamp formula

bhope51 ✭✭
edited 12/09/19 in Archived 2017 Posts

I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day.

=IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"), TODAY())

Is there a formula for inputting a date that will become static?

We are unable to use a date modified column as the row will continue to be updated and modified in other cells as employees complete the billing process.

Thank you for the help.


This discussion has been closed.