Is there a way to set up an automation to compare two columns then notify if a condition is met?
For example:
Column 1: Quantity of product in inventory
Column 2: Threshold to reorder product
When Column 1 < Column 2 set status to reorder then notify purchasing team.
Following - this would be useful.
The only thing I can directly recommend is to set conditions around each field. Example:
Scheduled Activation: X date
Complete Activation: X date
If SA date passes and CA is NOT complete, change Status to Service Activation Delayed.
It’s not a direct comparison but maybe this will help you. Good luck.
Hi Chase,
There are no native automations to compare 2 columns. You may want to look at the Advanced Formula Booster, a 3rd-party app that allows you to build formulas and automations.
With a simple formula and 1 automation (When ‘Qty in inventory’ changes, run the formula), you can achieve what you want:
The notification content can be a lot more elaborate and even use text formatting.
