Is it possible in smartsheet to change status automatically based on column dates?

Maryjo Reyes

Is it possible in Smartsheet to change automatically the Status column based on Date Received column and auto change Status once the Date Check Transmitted FMD Column was filled in? Thank you.

Hannah H

Hi @Maryjo Reyes,

Are you looking to have the status change is any date is entered into the Date Check or Date Received columns? If so, this should work:

=IF(ISDATE([Accounting (Date Check Transmitted to FMD)]@row), "Check Transmitted to FMD", IF(ISDATE([Accounting (Date Received)]@row), "Check Preparation"))

Hannah

Hannah H

Hi @Maryjo Reyes,

Are you looking to have the status change is any date is entered into the Date Check or Date Received columns? If so, this should work:

=IF(ISDATE([Accounting (Date Check Transmitted to FMD)]@row), "Check Transmitted to FMD", IF(ISDATE([Accounting (Date Received)]@row), "Check Preparation"))

Hannah

Maryjo Reyes

Hi @Hannah H,

Great! Thanks for your help. 😊