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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

Columns in an Excel Attachment Data Upload Auto Added to a Source Sheet
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
Do not have access to a sheet I created in another plan
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
No Admin Access on Sheet
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.