Forum Discussion
Linking Tasks to aggregate % complete
I have a group of 10 tasks , say group 1 tasks. These 10 tasks have a hierarchy among themselves.
I have another group of 100 tasks, say group 2 tasks. These 100 tasks have a hierarchy among themselves too.
Group 1 tasks are co-located. Group 2 tasks are co-located and they do not overlap.
The % Complete of each of the group 1 tasks, should be a roll up of a few of group 2 tasks. These group 2 tasks, can be located anywhere within the group 2 bundle, i.e. they won't be located sequentially.
How do I link a particular group 1 task with a set of group 2 tasks, to get an aggregated % complete value ? I can't put group 1 task as a summary task within group 2 block because that would make group 1 & group 2 overlap.
If I just link group 1 & group 2 tasks, it impacts the dates and not the % complete aggregation. So how do I link two tasks, without a Summary - Sub task relationship to roll up the % complete ?
Any thoughts ??
A hack, which I can think of is, if I can create a dummy group 2 task, which mirrors the actual task attributes of real group 2 task and place it within group 1 block, Group 1's task's % complete can be aggregated. But is there a way to "link" two tasks, so that one task mirrors other tasks attribute - like, if I change the task name / duration / % complete etc. of one task, it gets changed in other task too ? something like in excel linking of two cells.
Any thoughts on this too ?
- NKumar2010,
Can something like this be done? Probably, but without some VBA you won't be able to use the built-in % Complete field for the aggregated value, it will need be be shown in a custom field.
The first question is, what exactly is your definition of "aggregated % complete" (i.e. what is the formula)?
Excel has a much more open format with respect to linking cells. Since Project has a very specific data structure, linking information between tasks is very limited.
If you can provide a sample of your file structure, I can help you get what you want.
John- By % aggregated complete, I mean the rollup % complete. The way a summary task's % complete is a roll up value of sub tasks % Complete. Just that in my situation, the tasks which should contribute to the aggregated % complete of the higher task, are not the sub-tasks of this higher task. They are physically distributed within the file.
In a normal world, Summary Task A, will have rolled up % Complete values of it's child tasks.
In my case, Summary Task A, wants to have it's % complete values from tasks which are not it's own child task, but are located elsewhere in the file, and are other summary tasks child.
Is there a way to do it ?- NKumar2010,
Okay, thanks for the full explanation, it's what I assumed but it's always good to check. And yes, I can develop a way to do it but I need more details. Would you be able to send me your file?
John
- NKumar2010 --
If I understand your question correctly, I believe you are trying to calculate the % Complete values for selected groups of tasks. Here is something you might try:
1. Create a custom Text field named Task Group.
2. Add a lookup table to this custom field and include values like Group 1, Group 2, etc.
3. Insert this custom field in any Task view, such as the Gantt Chart view.
4. In the custom column, specify a value for each task, like Group 1, Group 2, etc.
5. To the right of the custom column, insert the % Complete column as well.
5. Click the AutoFilter pick list button in the column header of the custom column and then select the Group on this Field item on the pick list menu.
If you look at the % Complete column, you should see the aggregated % Complete value for each group of tasks. Just a thought. Hope this helps.- Let me give it a shot. Please see my reply above to John's post to get some clarity. How do I do step 2 i.e. add a look up table to a custom field ?
