Automate a response field


I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.


  • ker9
    ker9 ✭✭✭✭✭✭

    @Cath Jones

    Change the column names to match your column names. Add the formula to your Due Date column - ensure that it is setup as a Date column.

    =IF([Status]@row = "Open", [Created]@row + 35, "")

    This is giving you a date if status = Open, or blank for any other status.

    Hope this help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!