Change Color or the Harvey Balls/ Status Icon

Gaurav Chauhan

Hi Team,

I need to change the RYGB to add another 2 set of Colors for Gray and Purple and show as RYGBGP

Because, in my formulae, if I type Purple, it doesn't populate the Ball icon of this color, just returns Text.

Is this feasible in Smartsheet

Thanks!

James Keuning

No ability to change color or add symbols, but you can use conditional formatting to just format an entire cell.

Gaurav Chauhan

Hmm.. thanks for confirming the limitation/ standardized option.. Will stick with the available colors.

Thank you.

Bassam Khalil

@Gaurav Chauhan

Hope you are fine, you can't merge to symbols column set in one column.

Andrée Starå

Hi @Gaurav Chauhan

I hope you're well and safe!

Here's a possible workaround or workarounds

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!