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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 210 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 300 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!