Welcome!

Harvey Balls not changing

Why aren't my balls changing color? Here is my formula

=IF([% Complete]2 < 50, "Red", IF([% Complete]2 = 100, "Green", "Yellow"))

I have been stuck on this for awhile

Thanks,

Ken

There are possibly a couple things at play.

Percentages in Smartsheet are done with decimals. .5= 50%, .75 =75%, and 1 = 100%. So when you check for the percentage you need to do the decimal.
Harvey balls are not the RGB symbol column. If you're using the Harvey ball column symbol (as you stated) then you will need to use the verbiage that comes with those symbols (not intuitive). Harvey balls use "Whole", "Half", "Quarter", "Three Quarters", and "Full"

https://www.smartsheet.com/blog/support-tip-column-symbols

In either case, you will want to adjust your percentages to use decimals.

Recover recent deleted spreadsheet
I accidentally deleted the wrong spreadsheet I looked on the site and it says that I can recover it and the deleted the items tab but I don't have any options on my Smart sheet app or web.
Login Issue
Hi, I have five Smartsheet accounts—four with editor access and one admin account. Recently, I’ve been unable to log in to one specific editor account. It shows the message “Too many failed attempts. Try again after one hour or reset your password.” However, I attempted to log in only twice, and the error appeared on the…
How to enable a default view of a sheet shared with my team
I shared a sheet with a smartsheet group for my team. The default view is set to Grid view for some, even though I created a shared filter view with the Table view. How do I enforce Smartsheet to only show the Table view when going to the sheet.