I’m having trouble with my automation rules when I use a formula column as a trigger.
The situation is as follows: I have a table where certain information has to be filled out in two separate columns. When both columns have been filled out, I have a formula column with a checkbox that gets checked automatically.
I now want to trigger an automation rule whenever that checkbox gets checked. But for some reason, the rule fails to trigger.
If I set the trigger for one of the input columns, it fires when I type something in just fine.
Is it possible that formula columns don’t generate a modification event when they change?