Formula Help - IF Statements, RYG Balls

Plain language requirement:

Average Score < 3 = Red

Average Score >4 = Green

Average Score and <4 = Yellow

My current formula: =IF([Average Score]@row < 3, "Red", IF([Average Score]@row > 4, "Green"), "Yellow")

I am getting error "Incorrect Argument Set"



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!