Symbols for Status

Julie Bettinardi

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", "")))))

Etienne Mermillod

Hi Julie,

Is the column of the correct type (symbols) ?

A simple column formula is working on my side:

Etienne Mermillod

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.