I am trying to send automated notifications based on a greater than or less than. Here is the example:
When CONTRACTUAL # is less than ACTUAL #, notify someone.
There is a template close to this, but it requires a manual value added in place of ACTUAL # from my board. I can’t build a custom notification either on this, as far as I can tell. Need help in setting this up.
Hey Roman! This is in a formula column, correct? If so, it won’t be able to trigger any automations since formulas are not supported in automations at this time.
Could you explain a little more about your desired workflow so we can help suggest some alternative solutions for what you’re looking for? Also, if you could provide some more context for why a manual entry of the number doesn’t work for you, that would be super helpful!
The manual entry of the formula results in a numbers column would allow you to set up automated notifications like this: