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

snorthern · 01/09/24

Julie Fortney · 01/09/24

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.

Julie Fortney · 01/09/24

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.

snorthern · 01/16/24

Good morning Julie,

The suggested formula worked! Thank you very much!

Best Answer