The goal seems simple, automate a notification when the number of hours logged exceeds the preset budgeted hours.
The problem, I think, is both of the columns with data are created by formulas.
- Total time is the sum of sub-items (each a time entry).
- Budgeted hours is a simple number entry.
- % to Budget, which would be perfect to use for the notification, does the math of Budget to Total Time = %.
This Monday.com notification construct is exactly what is needed, but because the NUMBER (the Total Time column) is created from a formula it is not a selectable column - is this correct?
Recommendations on steps to make this seemingly simple equation work in Monday.com?