Issues with automation rules on formula column

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?

Hi Joeri,

You are correct. Changes to formulaic columns will not trigger automations. We’d like to support this in the future but for now, the best work around is to listen to the input columns.

Preeyanka

Hi Preeyanka,

Thanks for the reply. I tried setting the automation rules using the input columns, but I run into a different problem.

The rule triggers as expected now, but I am now evaluating the formulaic column in the condition step of the automation rule, where I get unexpected behaviour. The condition evaluates to false, even though replicating the same formula elsewhere returns true. This means that my automations are still not getting triggered, because of an error in evaluation in the second step. Is this a known bug?

I would be happy to share the specific document and circumstance where this occurs with you, if that helps.