symbols - words showing not colour

Laura_Murphy

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

 

Andrée Starå

Hi Laura,

Try this.

Grey should be Gray for Smartsheet to interpret it. I also updated your formula with @row, so you don't have to think about row numbers.

=IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Not Started", "Gray", IF(Status@row = "Delayed", "Red"))))

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Laura_Murphy

Thanks so much this worked perfectly. 

Really appreciate your help. 

Andrée Starå

Excellent!

Happy to help!