We use Monday.com to calculate sales teams KPI’s.
Based on them entering their sales for that day (in a numeric column) it should update 2 status columns.
The result for that day.
How they’re tracking month to date.
For some reason I cannot get a typical if function to work in make, where it assesses the sales amount entered against a target column and returns a value, which should then update the status column.
Thanks in advance!
Your syntax looks correct. Some questions: Are your status labels actually the colors shown? Can you give more detail about what exactly is not working? Are you getting an error, etc.?
Jim - The Monday Man
Thanks for getting back to me!
Labels - yes they’re correct - see below:
Uploading: CleanShot 2023-03-06 at email@example.com…
The error - as an example, see the below screenshot. This is returning ultra green, however should be returning red.
Thanks again Jim!
As a debugging step, I would try copying the formula into a Set multiple variables module and confirm the output of the formula.
You might also hit the refresh button for the column to make sure you have the up-to-date version of the column.
I ended up doing this, then using parseNumber on the set variable. For some reason it’s as if the number columns were being seen as a text string rather than a number.