RAG Status - Formula

SBash

Hi, 

I have currently formulated the following formula,

=IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red"))

which is working efficiently, but problem occurs it shows me the Wording not the Colours or symbols

 

Many Thanks

Andrée Starå

Hi,

Have you changed the column type to Symbols? You also have to update your formula because there isn't Amber in any of the Symbol presets. I would probably use RYG (Red, Yellow and Green).

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SBash

Hi Andree, 

Many Thanks for you quick reply, 

Yes it works

Thanks

 

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée