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 = "InProgress, OnSchedule", "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!