Symbols for Status


Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form

=IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue", IF(Status@row = "Paused", "Full", "")))))


Best Answer


  • Etienne Mermillod
    Etienne Mermillod ✭✭✭✭✭
    Answer ✓

    Hi Julie,

    Is the column of the correct type (symbols) ?

    A simple column formula is working on my side:

  • Julie Bettinardi

    Ohhh - I see. You're correct, I didnt have it as a symbol column. I was trying to avoid selecting one of the symbol category options because I wanted symbols across multiple categories (Circles in Green, red, yellow, blue, light grey, and dark grey). I was hoping a formula would solve for that but it appears not.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!