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

Options
Karen Hansard
Karen Hansard ✭✭✭✭
edited 05/18/23 in Formulas and Functions

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

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!