Traffic Lights for Project Plan

Kathleen M

I'm in need of setting up traffic lights (red, yellow and green) for my project plans (x5)

Under Schedule Health I would like the following reflected:

Any task which is overdue by 4 or more days based on their end date and not 100% completed to be RED
Any tasks which is overdue by 3 or less days based on their end date and not 100% completed to be YELLOW
Any completed tasks to be GREEN
Any tasks which have yet to be started (based on start date) to also be GREEN

When I have tried to build the formula myself I get "#UNPARSEABLE"

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

Kathleen M

Hi @Kelly Moore

Just had to update "due date" with "end date" and it has worked!

=IF([% Complete]@row = 1, "Green", IF([Start Date]@row > TODAY(), "Green", IF(AND([% Complete]@row < 1, [End Date]@row <= TODAY(-4)), "Red", IF(AND([% Complete]@row < 1, [End Date]@row >= TODAY(-3)), "Yellow"))))

Thank you so very much for you response!

Cheers,

Kathleen

All comments

Kelly Moore

Hey @Kathleen M

Try this

=IF([% Complete]@row = 1, "Green", IF([Start Date]@row > TODAY(), "Green", IF(AND([% Complete]@row < 1, [Due Date]@row <= TODAY(-4)), "Red", IF(AND([% Complete]@row < 1, [Due Date]@row >= TODAY(-3)), "Yellow"))))

Does this work for you?

Kelly

Kathleen M

Hi @Kelly Moore

Just had to update "due date" with "end date" and it has worked!

Thank you so very much for you response!

Cheers,

Kathleen

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.