RYG Ball & Status, Help needed

Naif AlQazlan

Hi,

I'm trying to create a RYG color based on Status column, I have tried:

Empty or Not started = RED

In Progress = Yellow

Complete = Green

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", Yellow, IF([Status]3 = "Complete", Green)))

=IF(Status3 = "Not Started", "Red", IF(Status3 = "In Progress", Blue, IF(Status3 = "Complete", Green)))

=IF(Status@3 = "In Progress"; "Green"; IF(Status@3 = "Potential Delay"; "Yellow"; IF(Status@3 = "Behind Schedule"; "Red"; IF(Status@3 = "Complete"; "Blue"))))  

I always get "Unparseable" am I missing something?

Paul Newcome

Try your first one again except put quotes around "Yellow" and "Green".

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", "Yellow", IF([Status]3 = "Complete", "Green")))

Paul Newcome

Try your first one again except put quotes around "Yellow" and "Green".

=IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", "Yellow", IF([Status]3 = "Complete", "Green")))

Naif AlQazlan

Many thanks Paul, worked like a Charm.

Paul Newcome

Happy to help! 👍️