Health column formula troubleshooting

I want my health column to show as gray for any complete item, green for anything with an end date more than 5 days out, yellow for anything due in 5 or less days, and red for anything past due. It's very close to working, but I cannot figure out why some of these lines are showing gray, when they should be green (such as the lines "BPM Documentation," "Identify Modification needed to Current state External BPMs" and a couple of others in this screenshot. My formula is below, any ideas for me?

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=IF([% Complete]@row = 1, "Gray", IF(TODAY() > [End Date]@row, "Red", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 5, "Yellow", "Green")))

All comments

Paul Newcome

Try this:

=IF([% Complete]@row = 1, "Gray", IF(TODAY() > [End Date]@row, "Red", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 5, "Yellow", "Green")))

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.