nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Harvey Balls not changing

Ken Arends

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

Find more posts tagged with

Comments

Mike Wilday

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt