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

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

Answers

  • Edward Townsend
    Options

    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.
    Genevieve P. Employee Admin
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!