2-Step Row Removal
In order to avoid accidental triggers of a row removal automation, I'm trying to set up a 2-Step process. Essentially I want someone to select "Remove" from the status dropdown & check a box next to the dropdown in order to trigger the automation. Picture below is of the automation logic, which currently does not work. If I remove the condition, then it does work. Am I doing something wrong or is this a limitation of the program?
Best Answer
-
The way you have your rule setup, the rule is only triggered when a row is changed AND the Status is changed to "Remove".
If the Status is already at "Remove" and then you check "Confirm remove" it won't trigger.
To make this work:
- remove the initial STATUS condition in the first box
- add a second condition in the "condition" pink box which says AND Status = Remove
That should work
Answers
-
The way you have your rule setup, the rule is only triggered when a row is changed AND the Status is changed to "Remove".
If the Status is already at "Remove" and then you check "Confirm remove" it won't trigger.
To make this work:
- remove the initial STATUS condition in the first box
- add a second condition in the "condition" pink box which says AND Status = Remove
That should work
