Automations using Conditions
Hello everyone. I am trying to create a useful automation for an inventory sheet. On the Sheet I have columns "Qty on Order" and "Qty Rec'd". I am trying to create an automation that will alert me if Qty Rec'd is less than Qty on order. How would I go about that?
If I set a condition "Qty rec'd is 'less than'", it wants me to enter a quantity instead of less than Qty on order.
Help Article Resources
Check out the Formula Handbook template!