1

Hi Smartsheet community,

I currently have a formula the runs when a column drop down is selected to "Completed" 

=IF(Status4 = "Completed", TODAY())

However, every time someone else saves the sheet, the formula runs again and overwrites the old stamped date.  This never happened before and I would like to know if there are any other solutions to prevent this from happening.

https://gyazo.com/8d0ec72d04dd82fa80597705e99e107d

Thank you so much in advanced.

-Nori

 

Department

Comments