Two Date fields with Automation



I have a smartsheet that manages our department tasks. I currently have workflow automation for setting the next due date for the task but would like to also change the "Completed Date" to blank at the time that the due date is updated. Is this possible?

Best Answer

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓

    Hi @hgiffear

    Yes, this is possible. I just tested it to be sure. In the Automation Menu, create a new one and choose "When rows are changed" chose "Due Date" changes to Any Value. Then choose "Clear cell value" in the Actions section and pick "Completed Date".

    I hope that helps.


    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner