Auto inputting a date based on a status change
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?
Help Article Resources
Check out the Formula Handbook template!