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

Best Answer

  • Julie Fortney
    Julie Fortney Overachievers
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!