Formula for Date column based on status change

JennS

I'm looking to create a formula to automatically put a date in a column based upon certain statuses in a dropdown menu. For example, I would like that day's date to populate when the status is 1, 2, or 3 but not 4 or 5 (we have about 10 different statuses in our actual list).

Is this something that is possible? 

Mike Wilday

Hi Jenn, 

Yes!! This is something that Smartsheets can do. Modify and place the following formula in the date cell. Modify as needed. Change the column names to match your own. If your column names do not have spaces and do not end in a number, then delete the brackets [  ] around the names. 

=IF(OR([status column name]1="text for status 1", [status column name]1="text for status 2", [status column name]1 = "text for status 3", [status column name]1 = "text for status 4"), today(), "")

You need to make sure you use the exact text of each of the fours statuses and be aware that the date will change tomorrow to tomorrow's date. There is not currently a native way to hardcode a date automatically in smartsheet.