How can I find the Unicode for a gray circle so I may use it with the UNICHAR function

Karen Hansard

I'd like to expand my RYG list to include gray in addition to red, yellow, green and blue. But how do I find the code so that I can use it with =UNICHAR(XXXX)?

My current formula is:

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))

I'd like it to be:

=IF(Status@row = "On Hold", "Gray", IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))) - but this just returns the word gray when I want a gray circle returned. Blue is already reserved for another meaning.

Thanks

Karen

Andrée Starå

Hi @Karen Hansard

I hope you're well and safe!

This might help.

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

More info:

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

https://getemoji.com/

https://www.vertex42.com/ExcelTips/unicode-symbols.html

Did 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

I usually use

UNICHAR(11044)

You'll have to apply conditional formatting to get it to change colors though (have to increase font size too). It starts off as a black circle, but it works the same as text in that you can change the "font" color.

Andrée Starå

Hi @Karen Hansard

I hope you're well and safe!

This might help.

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

More info:

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

https://getemoji.com/

https://www.vertex42.com/ExcelTips/unicode-symbols.html

Did 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Karen Hansard

Thank you Andree! Couldn't find the unicode for a gray circle, but found for another color.

Paul Newcome

I usually use

UNICHAR(11044)

You'll have to apply conditional formatting to get it to change colors though (have to increase font size too). It starts off as a black circle, but it works the same as text in that you can change the "font" color.

Andrée Starå

@Karen Hansard

Excellent!

Happy to help!

Karen Hansard

Thank you Paul. Have a great weekend!

Paul Newcome

Happy to help. 👍️

ker9

@Karen Hansard

If you are using Symbols as the basis for the column, you could change the column properties to include gray:

Hope this helps!

Karen Hansard

Thank you Ker9 for the response. I'm already using red, yellow, green and blue so needed a workaround to include a 5th color.

Karen Hansard

Peter South

Can we use unicode text in the sheets like we just copy paste it on social media platform to highlight something. I just type the text on the website https://socialmediafonts.com it convert it into fancy text that can be copied any where on different social media platforms like facebook and Instagram.