Generally speaking, I don’t think automations can detect changes from formulas. Al’s workaround actually depends on manual (or API) input to trigger the Row changed flag.
That’s the same principle for Modified on. It only updates when the formula code (including its references’ values) is modified, but ignores changes to the displayed/calculated value.
So you need to actively poll the table to detect any changes (that’s what happens when you Test the automation rule).
That can be done with a time-based automation. Then if you need more resolution than 1 hour, you’d fall under the same case as this one:
Integromat offers 15-min resolution. So what you can do is:
-
Set up a checkbox column on your table and create an automation to watch row changed and test if that checkbox is true.
-
Setup your Integromat connection, then create a scenario like this:
The first block is pretty straightforward. On the second one you need to map the row coming from the first block. Then you can do some logic to testStatusand update the checkbox.
After Integromat updates the row, the Coda internal automation will kick in.