Contract Expiry date less than 0,30,90,180 days from todays date apply RAG

Lee Rudd

I have a RAG dropdown column configured, a formula is required for the RAG to be applied against the following:

Expiry date 180 greater than todays date = Green

Expiry date is between 180 - 90 days greater than todays date = Yellow

Expiry date is between <0 - 60 days greater than todays date = Red

The Expiry date is a column and date formated.

Find more posts tagged with

Accepted answers

SmartLew

hi @Lee Rudd

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

All comments

SmartLew

hi @Lee Rudd

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

Lee Rudd

Thank you, that works, I have altered the days to remove gaps. Appreciate your guidance.

SmartLew

Happy to help!

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.