Adding stoplight task graphical indicators to project summary tasks in a master project

Question

Hello,

I am using microsoft project to track multiple projects in a master project plan.  Each sub project has stoplight indicators to show late and on-time tasks.  Is there a way to:

1. Have summary tasks and the project summary task display red or yellow if a red or yellow indicator appears for any task beneath them.
2. Can this indicator on the project summary task be made to show up in the master file when all tasks are rolled up into the project summary task?  So that in the master list of projects, there could be a stoplight indicator showing if there is a late or overdue task within that project- prompting you to open it and resolve the issue?

Thank you for your help!

Karen

Answer 1

same question like Karen, by the way:-)

Answer 2

hi Rod

im looking for this a long time

can you please tell me the formule to put in Number Field

i have this:

IIf([% Complete]=100;4;(IIf([Current Date]>=[Finish];3;(IIf([Current Date]>[Start] And [% Complete]=0;5;(IIf([Current Date]>[Finish]-14 And [% Complete]<80;2;(IIf([Current Date]<[Start];6;1)))))))))

but stil in problem to get it to project summary, can jou provide for the summary

• For summary tasks set a formula to show max value formula.

Thanks for help!

Rein

Answer 3

Yes. Problem is that a formula can only read data for the row, not for any other rows.

1. So first use a Number field, rename it to a meaningful name for you.
2. For tasks set it to show a 1 for yellow tasks or 2 for red tasks.
3. For summary tasks set a formula to show max value formula.
4. Copy the fields used to the Global file using the Organizer (be sure to rename the fields to avoid confusion, so they are available across all your projects.
5. Now in the Master file create a stoplight graphical indicator based on the Number field. If the max value is 1, set to yellow, max 2 - red.