how to ryg days prior to expiration, & after expiration

K8te

Need help with this formula. I have the first part

if "received" =green, if within 5 days before expiration date yellow, if = to or past expiration date red.

anything more than 5 days before expiration stays blank

I have tried many ways and can not get it to work.

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

Try this - but you need to change the column names in the formula to match your column names:

==IF(StatusNew@row = "Received", "Green", IF(Due@row >= TODAY(), "Red", IF(AND(Due@row <= TODAY(5), Due@row >= TODAY(-5)), "Yellow", "")))

K8te

This did not work for me. I attached.

Received=Green

Yellow if the date is 5 days before the expiration date "yellow", any thing that is the expiration date or past it "red"

anything prior to the 5 day window, "" or if the expiration date column is blank, ""

Andrée Starå

Hi @K8te

I hope you're well and safe!

Try something like this.

=IF([Permit Status]@row = "Received", "Green", IF(Due@row >= TODAY(), "Red", IF(AND(Due@row <= TODAY(5), Due@row >= TODAY(-5)), "Yellow", "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

K8te

Sorry for the late response.

Thank you

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.