I received a question about how to trigger an automation from a formula recently, and with the help of @Adam_Ginzberg came up with a solution. This is just a workaround for now, and we plan on making this easier to use in the future.
In the doc below,
Calculated Column outputs “Greater than 8” if the sum of
Input 1 and
Input 2 is greater than 8 (outputs “Less than 8” if the sum is less than 8). If we wanted to trigger an e-mail notification when the
Calculated Column is “Greater than 8,” we couldn’t do that with an automation since row-change automations do not detect changes in formulas. Instead, we create a
Calculated Column Cache that contains the hard-coded value from
Calculated Column and the automation changes the
Calculated Column Cache column to the value in
Calculated Column when the two values do not equal each other. You could string on more conditions in the Automation to check if the “cache” column equals a certain value so that the e-mail notification only runs under certain conditions.