Nested if for RYG Balls and qty not working

I am trying to use the RYG balls when noting when a variance has gone over certain amounts:

5000 or less - Green

5000-10000 - Yellow

over 10000 - Red

I can add grey as my false statement if the coordinator has checked off the completed box. This is the formula I have tried to build so far but I get the Unparseable error. I know I do not have the false statement included, but I'm not sure how to reference a checkbox.

=IF(Variance1<=5000, "Green", IF(AND(Variance1<=10000,(Variance1 "Yellow", IF(Variance1 >10000, "red")))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!