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
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.
-
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!