For Every one want to have More color symbol for health Status column.

Dear Community Memebers,

I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comments we can develop it to match the most of your wishes.

the following screenshot shows the color reference you can use it in your UNICHAR Function and a simple IF statement formula using those codes:

the Sample formula:

=IF(Color@row = "Orange", UNICHAR(128992), IF(Color@row = "Gray", UNICHAR(128280), 
IF(Color@row = "Red", UNICHAR(128308), IF(Color@row = "Blue", UNICHAR(128309), 
IF(Color@row = "Yellow", UNICHAR(128993), IF(Color@row = "Green", UNICHAR(128994),
IF(Color@row = "Purple", UNICHAR(128995))))))))

Find more posts tagged with

Comments

Genevieve P.

Hi @Bassam Khalil

Thank you for detailing your solution! I've moved this post into our Best Practice category.

Keep up the great work!

Genevieve

Bassam Khalil

@Genevieve P.

Thank you for your support.

Nero Naidoo

Thank you Bassam for always eing so helpful. You've made my job so much easier.

Abiola

This is a very useful information. Thank you Bassam.

Suresh Seetharaman

Thank You Bassam for your support. You have gone extra mile to help me find a solution. Thank you.

Sign in to join the conversation!

Quick Links

Trending discussions

How to bulk create cross sheet references using Python and Smartsheet API
Hello, This post provides a solution for quickly adding cross sheet references to a large number of sheets. The cross sheet reference refers to a single column. Caution The API code can update any sheet where you have permission to create cross sheet references. There is no way to automatically remove or edit cross sheet…