Symbols for Status

09/29/21
Accepted

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([email protected] = "Assigned / Not Started", "Empty", IF([email protected] = "In-Progress, On-Schedule", "Green", IF([email protected] = "Delayed", "Yellow", IF([email protected] = "Complete", "Blue", IF([email protected] = "Paused", "Full", "")))))

Popular Tags:

Best Answer

  • Accepted Answer

    Hi Julie,

    Is the column of the correct type (symbols) ?


    A simple column formula is working on my side:


Answers

  • Accepted Answer

    Hi Julie,

    Is the column of the correct type (symbols) ?


    A simple column formula is working on my side:


  • 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.

Sign In or Register to comment.