How to create an automation when the Actual PO Amount exceeds the Actual PO Requested Amount by $100
Best Answer

Hi @snorthern
You could add a helper column called something like PO Overage >100 with a simple formula. I suggest a checkbox column with this formula.
=if([Actual PO Amount]@row[Actual PO Request Amount]@row>100, true)
Then create your workflow to trigger when the PO Overage >100 column changes to true.
Answers

Hi @snorthern
You could add a helper column called something like PO Overage >100 with a simple formula. I suggest a checkbox column with this formula.
=if([Actual PO Amount]@row[Actual PO Request Amount]@row>100, true)
Then create your workflow to trigger when the PO Overage >100 column changes to true.

Good morning Julie,
The suggested formula worked! Thank you very much!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!