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
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!