Harvey Balls / Alternative to represent 5 Categories

Iris L.

Hello Everyone,

I'm looking for a solution to either get a colored Harvey Ball or a Symbol / Text to reflect 5 different categories: Grey - Green - Yellow - Red - Dark Red

Is there a way to avoid the conditional formatting solution I have in the first column below to get a Harvey Ball look & feel? (I would also be happy to have a colored box or any other symbol with good visibility - I tried ASCII Codes but as the Fonts are limited I only got a "empty box" symbol)

Thanks for any thoughts! Iris

Andrée Starå

Hi @Iris L.

I hope you're well and safe!

You can use other symbols by using UNICHAR, CHAR, or Emojis.

More info:

https://help.smartsheet.com/function/unichar

https://help.smartsheet.com/function/char

https://getemoji.com/

A great resource that Paul Newcome put together

https://app.smartsheet.com/b/publish?EQBCT=82f8fe0936a54758a3afa4b584acde07

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Iris L.

I hope you're well and safe!

You can use other symbols by using UNICHAR, CHAR, or Emojis.

More info:

https://help.smartsheet.com/function/unichar

https://help.smartsheet.com/function/char

https://getemoji.com/

A great resource that Paul Newcome put together

https://app.smartsheet.com/b/publish?EQBCT=82f8fe0936a54758a3afa4b584acde07

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Iris L.

Thanks a lot Andrée for the quick response - that helps a lot!

Have a fantastic week as well, Iris

Andrée Starå

@Iris L.

Excellent!

Thanks!

You're more than welcome!