I’m struggling with a formula ~ I have an ARR Field and what I’m looking for is a way to set a support level based upon Deal Value. So, say the deal value is greater than $ 20,000 then that would be marked Tier 1 ~ greater than $15k Tier 2 and greater than $5k Tier 3.
Monday AI Set this formula ~ but it’s not completing all the deals leaving many blank. Any help would be greatly appreciated:
Since you’re using greater than for each tier, the formula will only evaluate the first condition that matches, which might lead to blank results for some cases.
To fix this, try adjusting the formula slightly so that it checks the conditions in the right order. Here’s an updated version that should work: IF({Deal ARR} >= 20000, “High Tier 1”, IF({Deal ARR} >= 15000, “Medium Tier 2”, IF({Deal ARR} >= 5000, “Low Tier 3”, “”)))
Give this a try, and it should fill in all the deals as expected.