Help to link health status formula to status

Hi, Need some help here is my current formula for health status in project plan.

=IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue", IF(Status@row = "Out of Scope", "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY() + 3, "Yellow", "Green"))))))

Below is what I'm trying to show and change to link colours to Status but if past end date also flag as yellow.

Status	Colour	Timing
Not started	Blank/Grey	Linked to status
In progress	Green	Within the timeframe of the dates
In progress	Yellow	Behind on dates
Delayed - recoverable	Yellow	Not time bound (linked to 'delayed recoverable' status
Delay to plan	Red	Linked to status
Complete	Blue	Linked to status

Find more posts tagged with

Formulas

if formula

Accepted answers

All comments

There are no accepted answers yet

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.