symbols - words showing not colour

Laura_Murphy
Laura_Murphy ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello please can someone help with formatting? 

I can't understand why the word Grey is showing rather than the symbol? 

I've selected the set for the 4 colours from the symbol menu for the status column and created the below formula

=IF(Status15 = "Complete", "Green", IF(Status15 = "In Progress", "Yellow", IF(Status15 = "Not Started", "Grey", IF(Status15 = "Delayed", "Red"))))

 

Tags:

Comments