If Formula

So I'm working on a formula I just can't get right...

I'm trying to track expiration dates, so.. Id like...

Status to be Yellow if it's 60 days from today

red went is 30 days from today and Passed the expiration dated

and green for 61 days + if that makes sense

Please help !!!!

Find more posts tagged with

Accepted answers

All comments

Hello @Mstockbridge - I believe I have a formula to work for you. You'll need to change the [End Date] to whatever the "expiration date" column is named. Please try it and let me know.

=IF([End Date]@row > TODAY(+60), "Green", IF([End Date]@row > TODAY(+30), "Yellow", "Red"))

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.