Move Row automation not working
Answers
-
Here are a few ideas on what you can do to troubleshoot:
—Troubleshoot the sheet. Are people updating the column by typing "NO" or choosing from a symbol dropdown? If there's an inconsistency there that might result in confusion so that people are inputting something that is circumventing the automation, tighten down the specific inputs that are allowed
—Troubleshoot the trigger. As shown, the automation only triggers when a row that already exists is updated to the "No" symbol. If the row is CREATED with that "No" in place, then the trigger doesn't activate. Consider changing the trigger to "When rows are added or changed" and see if that matches your expectation.
—Troubleshoot the condition. Consider using the condition box to separate the trigger and condition, so that the trigger itself is unconditional - then you can segregate the condition from the trigger in your troubleshooting. Alternatively, you may wish to consider changing the trigger to a time-based one, and add a condition: Change the trigger to "When a date is reached" and then update to "Custom" as a Daily cadence - then add a condition "Where X is one of No". This will do move rows as a group once a day. See if that resolves your issue.If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives