Project Health formula Help needed

=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green"))))

These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time.

If scheduled end date is changed to 10% past original end date – RED

If scheduled end date is changed to 1-9% past original end date – yellow

If end date is less than 10 days from today and less than 75% complete - yellow

Neither of the above is true = Green

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Paul Newcome

Try this...

=IF(AND([End Date]@row <= TODAY(10), [% Complete]@row < 0.75), "Yellow", IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "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.