I cannot get my IF statement to automate Harvey Balls.
Hello. I have used RYG balls before to show statuses for dates. But I am wanting to use them based on the value of a single cell. I have tried various formulas but they are not working. Would anyone have advice on this? I have included a screenshot with the formula.
Answers

Try getting rid of the third IF and just have the final output of "Yellow".
=IF(.........., "Red", IF(........, "Green", "Yellow"))

Thank you for the support. Unfortunately this did not work. I know that I am just missing overlooking a small detail.

Hi @MDriggs
I agree with Paul! The reason you're getting an error is because of how you have the "or" written in  it would need to use the OR Function, with different syntax. However the statement you have there would be covered if you simply had "Yellow" as the final option without instructions.
=IF([Risk View Score]@row < 7, "Red", IF([Risk View Score]@row > 3, "Green", "Yellow"))
However this formula will always show you either Red or Green. This is because your first statement says "If the Score is less than 7, show Red". I have a feeling you might be looking to see if the score is greater than 7, not less than, is that correct?
Try this instead:
=IF([Risk View Score]@row > 7, "Red", IF([Risk View Score]@row < 3, "Green", "Yellow"))
If this doesn't work, it would be helpful to know exactly what it is you're looking to do for each colour, and what isn't working (incorrect result or formula error?)
Thanks!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
@Genevieve P. Good catch! I completely overlooked the operators.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!