What types of comparisons does the Number vs Column Trigger support?

It supports greater than, less than, and equal to comparisons between two numeric columns. You set the comparison direction and the trigger fires when the condition becomes true.

Can I compare a number column to a fixed value instead of another column?

This trigger is designed for column-to-column comparisons. If you need to compare against a fixed number, use the Formula Column Threshold Trigger instead.

Does the trigger fire every time the columns change, or only when they cross the threshold?

It fires only when the comparison result changes — specifically when the threshold is crossed. If both columns change but the comparison result stays the same, the trigger does not fire.

Trigger

Number vs Column Trigger

“When a number column compared to another column crosses a threshold”

Compare two numeric columns and trigger when the difference or ratio crosses a boundary you set. Perfect for budget vs actual, target vs achieved, and capacity monitoring.

Use Cases

Alert when actual spend exceeds the budgeted amount in another column

Trigger when hours logged surpass the estimated hours column

Notify managers when a project's earned value falls below planned value

Real-World Example

Your project board has 'Budget' and 'Actual Spend' columns. This trigger fires when Actual Spend exceeds Budget — automatically changing the status to 'Over Budget' and notifying the finance team, so overspend is caught the moment it happens rather than in a monthly review.

Ready to use this recipe?

Get Community Cookbook from the monday.com marketplace and unlock every custom trigger and action. Always £9.99/month — the recipe list keeps growing but the price never goes up.

Get the App Get monday Help