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.

Formula for Date column based on status change

edited 12/09/19 in Archived 2017 Posts

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
    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.

This discussion has been closed.