I’m trying to build a 9box formula into my Monday board, but Monday keeps telling me this is an illegal formula. Please help
=IF({Value}=“Low”,
IF({Cost}=“Low”,“5”,IF({Cost}=“Medium”,“8”,“9”)),
IF({Value}=“Medium”,
IF({Cost}=“Low”,“4”, IF({Cost}=“Medium”,“6”,“7”)),
IF({Value}=“High”,
IF({Cost}= “Low”,“1”,IF({Cost}=“Medium”,“2”,“3”)))))
Hi Lauren,
Remove the = at the beginning of your syntax. It seems to work fine otherwise.
Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.