See summarized duration/ % for header tasks

Kris Jacek

I have created a master sheet that links all my project gantt charts.

Unfortunately I cannot see the summerized totals - is this available as an automatic function?

I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!

Travis

Hi Kris, ifdependenciesare enabled parent rows will automatically show a weighted average of child row percent complete values. If your child rows are blank, the parent row will be blank as well. Try adding percent complete values to your child rows. If your parents rows are not rolling up, then its likely your percent complete column isnt associated with your dependencies. You can fix this by right clicking on a column header and select Edit Project Settings > Dependency Settings > Options > % Complete column > select your % Complete column here.

As for duration, the parent row Start Date will automatically show the earliest child row Start date and the End date will show the latest child row End date (ifdependenciesare enabled). The Parent row duration is the number of days between the parent row Start and End Date (not a sum of child row durations).