IF status symbol based on cell date or blank

Allison R

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

Amy Flores C

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.

Amy Flores C

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

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