Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

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

Answers

  • 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")

  • 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

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions