How to change Overall Health column from text to stoplight symbols

SLee

I have a formula in my Overall Health column that is based on the Status column. Green=Complete, Yellow=In Progress, etc. After multiple attempts I have a formula that seems to work but instead of getting the stoplight colors, I am getting the text instead, "Green" instead of the green dot. I assumed this was an issue with the column's properties but I am at a loss.

SLee

Yes, thank you. I knew it had to be something simple. I began with it as a symbol column but got dropdown boxes and then I changed it back to text. It looks great now!!

Andrée Starå

Hi @SLee

I hope you're well and safe!

Have you changed the column to a Symbol Type Column?

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

SLee

Yes, thank you. I knew it had to be something simple. I began with it as a symbol column but got dropdown boxes and then I changed it back to text. It looks great now!!

Andrée Starå

@SLee

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!