Can Smartsheet display five health color indicators?

LFeliciano

I have a sheet setup with five different statuses. I've been able to create a formula to display color indicators for four statuses, but when I tried to code in a fifth for Grey, I only see the text Grey in the row instead of the color. Are we not able to go past four colors?

Andrée Starå

https://community.smartsheet.com/discussion/139535/can-smartsheet-display-five-health-color-indicators

Hi,

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds
You can use Emojis for the colors instead.

🔴 🟡 🟢 🔵 🟠 🟣 🟤 ⚫

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

LFeliciano

How do you use the emoji's? I don't see that as an option in the column property or did I miss that?

Andrée Starå

https://community.smartsheet.com/discussion/comment/484755#Comment_484755

You can add them to the drop-down column option.

Make sense?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

LFeliciano

Thank you. That would mean that I would have to create all the choices and apply one of those choices to my rows. I was hoping to use the color indicators with a formula instead so that it reads another column and automatically applies the color ball in the health column.

SSFeatures

Hi @LFeliciano, you can use these emojis in a formula as well.

For example:

=IF(Value@row = 1, "🔴", IF(Value@row = 2, "🟡", IF(Value@row = 3, "🟢", IF(Value@row = 4, "🔵", ""))))

Also, great idea Andrée!

Hope this helps!

Andrée Starå

https://community.smartsheet.com/discussion/comment/484816#Comment_484816

Happy to help!

You can also use them in formulas by surrounding the emojis with "🔵", similar to how you use text in a formula.

Make sense?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!