Static Date/Time Time Stamp formula

bhope51

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.

Mike Wilday

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. 

bhope51

Thanks I will do that.

J. Craig Williams

This is how I do it using Zapier.

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

Craig