RYG balls formula displaying text only

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([email protected] = "Complete", "green", IF([email protected] = "Issue", "red", IF(ISBLANK([email protected]), "yellow", IF([email protected] - TODAY() < 0, "red", IF([email protected] - TODAY() < 7, "yellow", "green")))))

Output: (see attachment)

 

Smartsheet-formulat.PNG

Comments