Trouble with RYG Formula:

Beth Blome
edited 12/09/19 in Formulas and Functions

Can anyone tell me what I am doing wrong here?  I am trying to automate RYG balls from a % column.

=IF([% Complete]3 < 50, "Red", IF([% Comlete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!