RYG balls formula displaying text only

SherB

I've read through all the replies on this but have not found the resolution yet

I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date.  The new column Properties is RYG Balls

The formula works, but only shows as text

Formula i created:

=IF(Status@row = "Complete", "green", IF(Status@row = "Issue", "red", IF(ISBLANK(Finish@row), "yellow", IF(Finish@row - TODAY() < 0, "red", IF(Finish@row - TODAY() < 7, "yellow", "green")))))

Output: (see attachment)

 

Andrée Starå

Hi,

The names have to match exactly. Red, Green and so on.

Did it work?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SherB

I capitalized Red, Yellow, Green in the spelling and that worked!!

Thank you ;-)

Andrée Starå

Excellent!

Happy to help!