Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Workflow not Triggering

Community Champion
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.

image.png


Workflow below:

image.png


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

Answers

  • ✭✭✭

    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!

Trending in Formulas and Functions