% complete on a milestone task

[chris]

I use milestones to reflect the completion of a significant task. So the milestone has a dependency on taskX with durationY
Is there a way to have the milestone task automatically update the % complete when the % complete of its precedessor's % complete is updated.
Thank

 

[John Beamish]

If I understand you correctly then you want the %Complete from the task to
cascade to the Milestone. Milestones are, by definition, 0% or 100%
therefore you cannot have a partially complete milestone.

Try using the Tracking Gantt. You will see the progress of the summary
task and that might give you the information you want.

JLB, PMP

I use milestones to reflect the completion of a significant task. So
the milestone has a dependency on taskX with durationY.
Is there a way to have the milestone task automatically update the %
complete when the % complete of its precedessor's % complete is updated.
Thanks

--

 

[John]

Chris,
The simple answer is yes but implementing it is not so straightforward.
I can think of two ways to get what you want. One will do it indirectly
the other directly.

The indirect method is to substitute a mock % Complete field for the
"real" one. Use a spare text field to create a custom field called %
Complete. Then for each milestone use a formula to put 100% in the mock
field when the predecessor task is complete.

The direct method is to use a simple VBA macro. The macro would check
the predecessor of all milestones and if the predecessor is 100%
complete then the milestone % Complete would be set to 100%. The macro
could be set up to run using a single button click or run when the file
is opened or closed.

John