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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!