Automations using Conditions

Options

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.

Any ideas?

Tags:

Best Answer

  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭
    Answer ✓
    Options

    Ha, good catch, if blank is not considered less. then I would put an IF statement around the whole thing. With this formula, I made the assumption that zero and negatives are legitimate possibilities. If not, you can use <> or '>' with a number.

    =IF(ISNUMBER([Qty Rec'd]@row), IF([Qty Rec'd]@row < [Qty on Order]@row, 1, 0))


    Thank you,

    Kevin

    Happy to help if I can.

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!