Automation trigger


Is there any way to specify the "change from" value in an automation workflow trigger? For example, I need to trigger a workflow when Quarter changes from "Unslotted" to "Q2 - 2022" but not trigger it when Quarter changes from "Q1 -2020".

Best Answer

  • Paul H
    Paul H ✭✭✭✭✭✭
    Answer ✓


    Add helper checkbox column called "Was Unslotted"

    Workflow 1

    Trigger When Quarter Changes to "Unslotted" > Action Change cell valve "Was Unslotted" Checked.

    Workflow 2

    Trigger Whenever Quarter changes anyvalue >Condition "Was Slotted is Checked > Action1 what you need> Action2 clear cell "Was Unslotted".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!