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

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.

Best Answer

  • Hannah H
    Hannah H ✭✭✭✭✭
    Answer ✓

    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"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!