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
-
Hi Julie,
Is the column of the correct type (symbols) ?
A simple column formula is working on my side:
Answers
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!