How to change Overall Health column from text to stoplight symbols


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.

Best Answer

  • SLee
    Answer ✓

    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!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!