Can you create additional symbols? I need more than just 4 R-balls?

Leann Gibson

I want to have five colors not just the RYGG or RYGB. I want RYGGB but don't see that has an option.

Leann Gibson

Google Chrome, due to company policy I am not able to share the sheet. I am going to try this on my MAC.

Chris Mondeau

Hi @Leann Gibson ,

You might be able to get around this by using emojis with different colored circles: https://emojipedia.org/symbols/

In Smartsheet you would create a drop-down list, then copy/paste the emoji's you want to use as drop down values.

Hopefully this helps!

Andrée Starå

Hi Leann,

You could maybe use Emojis or other special charters.

I’ve done that in some client solutions.

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Leann Gibson

If I do this, can I still use this formula to trip the At Risk flag: =IF([Health Check]3 = "Red", 1, IF([Health Check]3 = "Yellow", 1))

Andrée Starå

@Leann Gibson

Yes, but you'll change the true part to an emoji or similar.

Leann Gibson

Great, will try now. Thanks again for the help

Andrée Starå

@Leann Gibson

You're more than welcome!

Here's a great resource with emojis.

https://getemoji.com/

Leann Gibson

For some reason the site is not allowing me to copy them or they come over as blank squares.

Andrée Starå

@Leann Gibson

Make sure that you select it and not only right-click and copy.

Leann Gibson

Will need to see what is happening, no matter what emoji site I use I get this.

Andrée Starå

@Leann Gibson

Strange!

Which browser are you using?

Can you share the sheet with me and I'd be happy to test.

Leann Gibson

Google Chrome, due to company policy I am not able to share the sheet. I am going to try this on my MAC.

Andrée Starå

@Leann Gibson

Ok. Let me know how it goes!

Ezra

Just in case anyone needed... you can use the "normal" unicode symbol UTF code as well.

for example:

=UNICHAR(HEXTODEC("1f4ca"))

will give you the 📊 bar-chart symbol

Andrée Starå

@Ezra

Thanks! I always forget those.

😜

Ezra

This is what I use instead of RYGB. Individual tasks get balls.. projects get blocks.. there's also some miscellaneous other symbols for other purposes.

The "Image" column is a pasted emoji-ish character from one of the sites like getemoji.com, while the "Code" column contains the actual unicode as a formula =UNICHAR(HEXTODEC("1F534")) Then I reference the columns with an index-match based on whatever I need.