How can I get automation to send alert when one column is less than another column

I have values in my inventory column that fall below my minimum order quantity column. How can I set up an automation to alert me when the inventory column falls below the minimum order quantity column

Best Answer

  • Anelise Wilhelm
    Anelise Wilhelm ✭✭✭✭
    edited 03/01/22 Answer ✓

    @Tracy Ashton It's something like this:

    Create a new column to be used as a flag (I usually set this as a checkbox column). I"m calling mine [Below Minimum] in this example.

    In my example the other two columns are [Inventory] and [Minimum Order Quantity].

    Then place the following formula in the [Below Minimum] column.

    =IF(Inventory@row < [Minimum Order Quantity]@row, 1, 0)

    So, when the inventory is below the minimum then the checkbox gets checked.

    Create an automation to notify someone that is triggered when [Below Minimum] changes to IsChecked. Once everything is working as you want, you can also hide the flag column so that other people don't get confused by it. It will still work while hidden.

    Let me know if this works for you 😃