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
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.
Comments
-
This functionality has been greatly desired for some time. I suggest that you Submit a Product Enhancement Request and add your vote to many others.
-
Thanks I will do that.
-
This is how I do it using Zapier.
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
Craig
