Formula column automations

Automations designed to support formula columns include [formula] in their sentence, e.g.:

Notes about formula column automations

1. All formula operations are supported.

2. Formulas referencing mirror columns are partially supported. In case you get an error that your formula is not supported, you have two options:

   • Clone mirror column to a standard column using mirror column automation and use this standard column in the formula.
   • Contact us, and we’ll do our best to support your formula as soon as possible.

Formula automation change trigger

The app supports triggering automations when a formula column recalculates. This is useful when you want to keep a formula column and its copied value synchronized automatically.

Caution

To enable this feature, the app must create a webhook for each column referenced in the formula. These webhooks are fully managed by the app and cannot be removed manually. Webhooks are cleaned up when the automation is removed, unless another automation relies on the same webhook. Be aware that using this trigger may result in a large number of webhook events.

The automation triggers whenever the formula is recalculated. This does not necessarily mean that the formula result has changed.

Limitations

The formula change trigger will not activate in the following situations:

1. When formula references {Group} and group changes
2. When formula references {Board} and board name changes
3. When formula references {Name} and board name changes
4. When formula references {Person#Names}, {Person#Emails} or {Person#PhoneNumbers} and person’s name, email or phone number changes
5. When TODAY() function gets recalculated

All other scenarios are supported, including nested formulas and formulas that reference mirror columns.

Caution

If the formula syntax changes (for example when you reference a new formula) the automation needs to be recreated.