Formula Help

Good morning Community,

Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense!

=IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <= TODAY(), "Red", IF([Scheduled Date]3 <= TODAY(10), "Yellow", IF([Scheduled Date]3 >= TODAY(10), "Blue")))))

Thank you.

Find more posts tagged with

Formulas

Accepted answers

All comments

Nick Korna

Hi @Lee Wood ,

Change:

IF([Scheduled Date]3 <= TODAY(), "Red"

To:

IF([Scheduled Date]3 < TODAY(), "Red"

At the moment it is also including equal to, whereas you don't want it to.

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.