Status is <> Complete and the Need by date is behind todays date then should change symbol to RED

IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green.

Been striking out... here was my latest try

=IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))

Find more posts tagged with

Accepted answers

Laura B.

Try this:

=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")

All comments

Laura B.

Try this:

=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")

Greg Zinn

Thank you this worked amazing!!!!

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.