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

Leann Gibson · 06/11/20

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 · 06/11/20

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 · 06/11/20

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å · 06/11/20

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 · 06/11/20

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å · 06/11/20

@Leann Gibson

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

Leann Gibson · 06/11/20

Great, will try now. Thanks again for the help

Andrée Starå · 06/11/20

@Leann Gibson

You're more than welcome!

Here's a great resource with emojis.

😋 Get Emoji — All Emojis to ✂️ Copy and 📋 Paste 👌

https://getemoji.com/

Copy and paste every emoji with 👍 no apps required. 😊🥺😉😍😘😚😜😂😝😳😁😣😢😭😰🥰

Leann Gibson · 06/11/20

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

Andrée Starå · 06/11/20

@Leann Gibson

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

Leann Gibson · 06/11/20

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

Andrée Starå · 06/11/20

@Leann Gibson

Strange!

Which browser are you using?

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

Leann Gibson · 06/11/20

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å · 06/12/20

@Leann Gibson

Ok. Let me know how it goes!

Ezra · 06/12/20

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å · 06/12/20

@Ezra

Thanks! I always forget those.

😜

Ezra · 06/18/20

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.

Formulas and Functions

Formulas and Functions

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

Best Answer

Answers

😋 Get Emoji — All Emojis to ✂️ Copy and 📋 Paste 👌

😜

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Finding if a date falls in a range in a referenced sheet

CountIF contains name from a contact list help needed

Formula for averaging days