Using Numbers column instead of "value" for "less than/greater than" automation

Feature requests
,
1

Hi there,

I’m requesting that you be able to select a number column instead of a static value for certain automations, ie; “When a NUMBER (number column) is GREATER THAN/EQUAL TO/LESS THAN a VALUE (static value), change STATUS to SOMETHING” modified so that rather than a value I can select a numbers column. Bonus points if it’s able to use Mirror columns.

For my use case I have a separate numbers column called “Minimum Stock” which is a numbers column with manually entered numbers and are different per item. Since this feature currently isn’t supported I’m using a formula column as a psuedo-Status column, but since formulas are also not currently supported in automation I can’t use the formula column to trigger other automations. All I can do is set up flags and filters and manually modify status columns once my formula tells me I need to.

I think this would massively improve automation workflow. For example, if X numbers column falls below Y column’s value, it can change Z status column. Since “Status” columns are heavily supported by automation all sorts of automation could take place; notifying users, moving the item to certain groups, emailing certain people etc.

2

I think it would be essential to be able to do this.
There are countless situations that could be useful.

3 Likes
3

Agreed! For our use case, we could track our orders by automation after importing shipping report. (when Order Qty = Shipped Qty, set status to Shipped)

This feature would mean one person could update the report in 5 minutes once a day, instead of 10 people updating the report manually updating as items ship.