Automation that is triggered by a function

Isabelle Mercier

Hello, we'd like to suggest an automation flow that works when a row is updated via a function.

In our case example we have a row, say row 100, where information is being input.

Let's say row 92 is our target row to trigger the automation and its contents are a function of the sum of rows 93 through 100.

We'd like to be able to have (in our example) an automation that when row 100 reaches a certain number, an automation is triggered. Right now this appears to not be currently possible.

Thanks for considering this!