Use change in formula field as a trigger?

Automations Builder
1

Hi!

I’d love to use changes in a formula field as a trigger for automations.

Example: I have a formula field that calculates the net worth of a project. The project has assets and debts that change over time in a third, linked table.

When those assets or debts change, the net‑worth formula is updated. If that formula change could be detected as a “field changed” event, I could automatically:

  • create a new row that stores the current net worth

  • add a timestamp

This would let me track how net worth evolves over time without manual updates.

Is there any way to treat formula recalculations as a change that can trigger automations, or any recommended workaround to achieve this?

2

Good morning @Caesar,

We have an open issue, #4593, which I believe would resolve this problem for you. Once we have implemented this, for any field (not just formulas), you will be able to compare the previous and new values and decide if a workflow should continue in its run or not.

I hope this helps!

Cheers,

Peter Evans