Changing Color Symbols by Number of Days from Due Date

I'm trying to show the risk of a project running off of today's date compared to due date.

Here is the criteria:

If less than or equal to 3 days to due date from today color Red.

If greater than 3 days but less than 8 days to due date from today color Yellow.

If greater than or equal to 8 days to due date from today color Green.

Here's what I have but I keep getting an Unparseable error:

=IF([Pendo Due Date]@row <= Today (3), "Red", IF(AND([Pendo Due Date]@row > Today (3), [Pendo Due Date]@row < Today (8)), "Yellow", IF([Pendo Due Date]@row >= Today (8), "Green", ))

Find more posts tagged with

Accepted answers

Jessica Krueger

Dumb mistakes on my part. Thank you for looking at it.

All comments

Jeff Reisman

Try this. There were a few issues with yours. First, TODAY() is a function and should be capitalized, with no space before the (0). There was a missing parentheses to close out your AND statement. And there was an extra comma at the end.

=IF([Pendo Due Date]@row <= TODAY(3), "Red", IF(AND([Pendo Due Date]@row > TODAY(3), [Pendo Due Date]@row < TODAY(8)), "Yellow", IF([Pendo Due Date]@row >= TODAY(8), "Green"))

Jessica Krueger

Dumb mistakes on my part. Thank you for looking at it.

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.