If my status column is Complete, I want the ball to turn "blue"

System

This discussion was created from comments split from: RYG Status column, IF/AND/OR formula help.

Edward Townsend

I have a similar issue, If my status column is Complete, I want the ball to turn "blue"

This is the current formula and it works perfect:

=IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green"))

I tried to add the turn blue on complete, and can't get it to work.

=IF(STATUS@row = "Complete”, “Blue”, IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green")

Genevieve P.

Hi @Edward Townsend

The syntax of your formula is correct, but it looks like the quotes you're using may be the wrong type. See how there are two types of quotes around "Complete”?

The first is straight: " and the end one is curved: ”

Smartsheet needs the straight ones. You'll want to write the formula directly into the cell in Smartsheet so the correct quote types will automatically be used!

Try this:

=IF(STATUS@row = "Complete", "Blue", IF([Target End]@row <= TODAY() - 15, "Red", IF([Target End]@row <= TODAY() - 30, "Yellow", "Green")))

Cheers!

Genevieve