IF status symbol based on cell date or blank

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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.