IF status symbol based on cell date or blank

Options

I'm trying to write an IF formula to return a status symbol based on if a date column in my sheet is in the past OR is blank. Smartsheet keeps telling me my syntax isn't quite wrong, and I'm having trouble seeing where I've gone wrong. Here's what my formula looks like right now.

=IF(ISBLANK([Expiration Date]@row), "Red", (TODAY() - [Expiration Date]@row > 0, "Red", IF(TODAY() - [Expiration Date]@row > -30, "Yellow", "Green")))

Tags:

Best Answer

  • Amy Flores C
    Amy Flores C ✭✭✭
    Answer ✓
    Options

    I have a formula that is returning a red ball if the date is blank.

    =IFERROR(IF([Dispatch Date]@row <= TODAY() - 14, "Red", IF([Dispatch Date]@row <= TODAY() - 7, "Yellow", IF([Dispatch Date]@row <= TODAY(), "Green"))), "")

    Hope this can helps you.

Answers

  • Amy Flores C
    Amy Flores C ✭✭✭
    Answer ✓
    Options

    I have a formula that is returning a red ball if the date is blank.

    =IFERROR(IF([Dispatch Date]@row <= TODAY() - 14, "Red", IF([Dispatch Date]@row <= TODAY() - 7, "Yellow", IF([Dispatch Date]@row <= TODAY(), "Green"))), "")

    Hope this can helps you.

  • Allison R
    Options

    Thanks! That worked for changing all the blank cells to be red, and the rest of my status symbols are working great, too!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!