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(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)

Find more posts tagged with

Formulas

Solution Center

Community Platform

Project Management

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…