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))))))))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Comments
-
Thank you for detailing your solution! I've moved this post into our Best Practice category.
Keep up the great work!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for your support.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you Bassam for always eing so helpful. You've made my job so much easier.
-
This is a very useful information. Thank you Bassam.
-
Thank You Bassam for your support. You have gone extra mile to help me find a solution. Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives