Hello monday.com community! My request is for the ability to compare number columns and together with an automation change a status column. For instance, ‘Quantity Needed’ column is 25, where as ‘Quantity Done’ column is 20. When this happens it would be amazing to change my status to ‘Incomplete’. Please make this possible 
You’re right of course—but I don’t think it’s reasonable to assume everyone has an Enterprise plan.
Without access to the Workflows feature, you have a few other approach options.
Formula column (currently requires Pro+ subscription)
This is a bit of a cheat because the formula column doesn’t update an existing Status column—instead, it basically becomes its own status column.
You can write a formula that displays text based on logic applied to other columns:
This formula displays “INCOMPLETE” if Number2 (the number you HAVE already) is less than the value in Number1 (the number you NEED) OR if Number2 is just empty. Otherwise, it displays “COMPLETE”.
You can even add conditional formatting to apply colors to the various options if you’d like:
Which would look like:
AI Column (currently requires Standard+ subscription)
An alternate approach would be to use a custom AI column with basically the same logic. [Bonus: AI columns can be used—in a limited capacity—to trigger board automation recipes, while Formula columns cannot!]
Column type: Custom AI Prompt
‘Based On’ Dropdown: Custom action
Instructions:
You job is to determine whether the item is “COMPLETE” or “INCOMPLETE”, based on the following logic:
If {Number2} is greater than or equal to {Number1}, display “COMPLETE”.
If {Number2} is empty, OR if {Number2} is less than {Number1}, display “INCOMPLETE”.
You could apply conditional formatting for this column too:
NOTE: This technique displays those status values in the AI column, not in an existing Status column.
If you specifically need an existing Status column updated, there are some creative workarounds to be had—I bet I could figure something out. LMK!