Harvey Balls not changing

Options
Ken Arends
edited 12/09/19 in Smartsheet Basics

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

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    There are possibly a couple things at play. 

    1. 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. 
    2. 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.