Workflow not Triggering

L_123
L_123 ✭✭✭✭✭✭
edited 11/19/20 in Formulas and Functions

I have a move workflow that should trigger when a checkbox is checked. The checkbox (picture below) has the column formula:

=IF([Row#]@row > 50000, IF(IFERROR(MATCH([Row#]@row, {QC_Results_DB Row#}, 0), 0) > 0, 1, 0))

This formula triggers correctly, and checks the box when it should. The issue is that the workflow isn't triggered.


Workflow below:


All of this seems really basic, I don't know what i'm missing. Anyone see any issues?

Answers

  • Aravind GP
    Aravind GP ✭✭✭

    Hi,


    Workflows gets triggered when the conditions/trigger logics are met but executes only when you save. Whenever the sheet is saved and at that time if the trigger criteria is met, it should work. Also check to ensure that your target sheet has not hit the cell limit.

    Thanks,

    Aravind

    Associate Director

    Copernicus Consulting Pte. Ltd.

    P: +65 9230 5657 | E: aravind@copernicusworld.com

    Feel free to reach out for licenses, services, and training on Smartsheet

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!