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.
Help Article Resources
Check out the Formula Handbook template!