Auto inputting a date based on a status change

Hi,

I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. 

Is there a function to do that?

Regards

Mike

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!