Formula for R,Y, G Harvey Balls
I am trying to generate a formula that will turn the Harvey Balls in a cell to the color of their matching steps. For example, I have 21 steps all numbered 1 thru 21. I want the HB to be green if the steps are greater than or equal to 16. I want the HB to be yellow if the steps are greater than 11 but less than 15. And red if the steps are greater than or equal to 11. I have tried several formulas and end up with "unparseable" on all:
=IF([Steps]17 >= 16, “Green”, IF(AND([Steps]17 > 11, [Steps]17 < 15), “Yellow”, IF([Steps]17 <= 11), “Red”)))))
=IF(And(Steps for Harvey Balls19 > 0, (Steps for Harvey Balls19 < 11), "Red", IF(AND(Steps for Harvey Balls19 > 16,(Steps for Harvey Balls19 = 16), "Green", IF(AND(Steps for Harvey Balls19 > 11, (Steps for Harvey Balls19 < 15), "Yellow"))))
These are two that I used from other examples but neither work. The first one seems the most right. I think it may be a ( or ] out of place?? Any suggestions on how to fix my formula? Thanks.
Comments

Try the first one and remove the brackets. If your column name is only one word you don't need the brackets. It also looks like you had too many closing parentheses.
=IF(Steps17 >= 16, “Green”, IF(AND(Steps17 > 11, Steps17 < 15), “Yellow”, IF(Steps17 <= 11), “Red”)))
Let me know if that works.

your description and your examples don't quite match, particularly around the boundary cases. Below code is yellow from 1215, red below, green above.
=IF(Steps1 >= 16, "Green", IF(Steps1 > 11, "Yellow", "Red"))

This one still came back as "unparseable" Thanks. The below solution did work though.

This one worked. Thank you very much!!

Cool. Glad you got it working.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 283 Events
 33 Webinars
 7.3K Forum Archives