RYG balls formula displaying text only

SherB
SherB
edited 12/09/19 in Formulas and Functions

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)

 

Smartsheet-formulat.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!