Workflow Not Working
I have a workflow to copy rows to another sheet if a checkbox is checked (the checkbox column has a formula in it to make it checked depending on another cell). Please see the attached images for what the setup looks like. The rows are all pre-populated due to formulas required in each to calculate out information. That's why I have the trigger setup for when rows are changed. I'm not sure if the formula is causing the issue to not allow the trigger to occur because technically there's data in the cell already.
Best Answer
-
Could answer be here? https://help.smartsheet.com/articles/2479236-trigger-blocks-define-when-your-workflow-is-executed?_ga=2.157552627.856747175.1660191535-1319501804.1607986658
Cheers.
Forever forwards Backwards never.
Answers
-
Is the 'Resources' column a formula? Does it have cross sheet references?
-
Yes - it's a formula that performs an index/match to another sheet.
-
Is it never processing or only processing when you go into the sheet?
-
I can't get it to process. Even tried making copies of the sheet to get it to pull over.
-
Could answer be here? https://help.smartsheet.com/articles/2479236-trigger-blocks-define-when-your-workflow-is-executed?_ga=2.157552627.856747175.1660191535-1319501804.1607986658
Cheers.
Forever forwards Backwards never.
-
Yup - I think that's the answer, unfortunately. Thank you for sharing with me!
To prevent an infinite loop or circular reference, actions that will automatically modify the sheet cannot be triggered by inbound cell-links, cross-sheet formulas, or formulas that refer to another cell with an inbound cell link or cross sheet formula. This includes Request an approval, Move rows, Copy rows, Lock rows, Unlock rows, Record a date, and Assign people. For example, if the Status cell on the row is populated by a formula pointing to a cell with a cell link from another sheet, changes to that cell value through the cell link will not trigger a workflow that locks the row when Status changes to Complete.
Help Article Resources
Categories
Check out the Formula Handbook template!