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)
