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!

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

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!

=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