Formula based on date and status columns

I currently have the below formula in a column titled "Health' to create a symbol if the request was created more than 21 days ago (red) or less than 21 days ago (green). However, I want this formula to also include the status column that would include "received" or "open" and exclude the "submitted" status. How do I do this?

Current formula without status column being included:

=IF([Request Creation Date]@row < TODAY(-21), "Red", "Green"

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Good evening,

Try:

=IF(AND([Request Creation Date]@row< TODAY(-21), Status@row <> "submitted"), "Red", "Green")

Work?

Mark

Linda Funk

I inserted the below formula, (note: the accurate column title is "Submitted (SOW presented to requester, waiting response)" and the rows that have been submitted are still returning a red or green symbol.

=IF(AND([Request Creation Date]@row < TODAY(-21), Status@row <> "[Submitted (SOW presented to requester, waiting response)]"), "Red", "Green")

Mark Cronk

Try:

=IF(AND([Request Creation Date]@row < TODAY(-21), [Submitted (SOW presented to requester, waiting response)]@row <> "Submitted"), "Red", "Green")

Work this time?

Mark

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.