Within the Monday.com CRM, Deals tab I have created three columns of “Close probability”, “Top Project” and “Formula”.
I have tried this following formula on the “Formula” tab on the 100% selection but it populates the “Formula” column with a number 5 and does not give the “Top Project” any star rating.
IF({Close Probability}=“100%”,{Top Project}5)
What I want to automate is the following:
- When “Close probability” is 100%, rate “Top Project” with a 5 star rating
- When “Close probability” is 75%, rate “Top Project” with a 4 star rating
- When “Close probability” is 50%, rate “Top Project” with a 3 star rating
- When “Close probability” is 25%, rate “Top Project” with a 2 star rating
- When “Close probability” is 0%, rate “Top Project” with a 1 star rating