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:
IF({Deal ARR} > 20000, “High Tier 1”, IF({Deal ARR} > 15000, “Medium Tier 2”, IF({Deal ARR} > 5000, “Low Tier 3”, “”)))