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.

Completed date stamp formula runs when sheet is saved every time

nori.saito32131
nori.saito32131 ✭
edited 12/09/19 in Archived 2017 Posts

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

 

Tags:
· Share on FacebookShare on Twitter

Comments

This discussion has been closed.

Categories