Failed to do automation when a field changed, and the field is formula based.
Hello fellow, hopefully you can help me out with my question.
so I have a checkbox column that needs to trigger a "Move Row" automation, and the column is a column formula, and it just seems like not functioning as I want.
As you see on the image, Column 2 is the checkbox also a column formula, which needs to trigger the entire row to send to another sheet when checkbox is checked.
thanks!
Answers
-
Hi @Roy Yue ,
Can you do a screenshot of your automation workflow so that we can check it out?
-
There is no wrong with your automation, except for the "copy rows" should be "move rows" as you mentioned, but it's ok if that's what you want.
In case the automation did not function as you want, we may check the formula in Column 2. Can you show it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!