Automated RYG Based on % Complete Formula Help

Hi,

I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? 


When I enter in each element of the formula separately, they work. However, I am unable to combine them successfully. 

Separately: 

=IF([% Complete]3 = 1, "Green"), 

=IF([% Complete]3 <= .50, "Red"),

=IF([% Complete]3 <= .99, "Yellow")


Combined: 

=IF([% Complete]3<= 0.50), "Red"), IF([% Complete]3<=0.99, "Yellow"), IF([% Complete]3= 1,"Green")))


Any information you can send me about this #unparseable error is greatly appreciated.


Thanks,

Susie

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!