Nesting IF Formulas & Status Change

I'm using a sheet to track status of contracts based on their expiration dates. The formula below is what I've set up to try to show that I want the status to be GRAY for no expiration date, RED if the contract has expired, YELLOW if there are 30 days or less until expiration, and GREEN if there are more than 30 days until the contract expires.

=IF([Expiration]23 "", "Gray", IF([Expiration]23 < TODAY, "Red", IF([Expiration]23 < TODAY(30), "Yellow", IF([Expiration]23 = TODAY(30), "Green"))))

It keeps giving me an UNPARSEABLE error message--not sure what I can/should do to fix it. Can anyone help?

Find more posts tagged with

Formulas

Accepted answers

All comments

Sara Thibodeaux

It looks like you are missing "=" on the first check function. I am not super savy with formulas so there could be something else going on that is also an issue that I don't see. Hopefully that was the only thing. Hope this helps!

=IF([Expiration]23 = "", "Gray", IF([Expiration]23 < TODAY, "Red", IF([Expiration]23 < TODAY(30), "Yellow", IF([Expiration]23 = TODAY(30), "Green"))))

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.