Recognizing and Averaging Nested Tasks

[ErikC]

Hello, I'm working on a project management spreadsheet and having 1 issue, automating % done. I need the sheet to look at the column A, "WBS", and calculate percentage done based on sub-tasks within that project. For example, 1 = Product Development, 1.1. = Need Development, 1.1.1 = Reviews and Ratings, 1.2.1 = Consumer Focus Group Testing ... I need the book to understand if there is a subtask assigned to a parent task, and then the employee would simply update the subtask %done and any parent task would update appropriately.

example from above

1 = Product Development (20% - there are 5 parent tasks under this task and only one was completed), 1.1. = Need Development (50%), 1.1.1 = Reviews and Ratings (100%), 1.2.1 = Consumer Focus Group Testing (0%)



[TABLE="width: 838"]
<colgroup><col><col><col span="4"><col><col></colgroup><tbody>[TR]
[TD]WBS[/TD]
[TD]Task[/TD]
[TD]Lead[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Cal. Days[/TD]
[TD]% Done[/TD]
[TD]Work Days[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Product Development[/TD]
[TD] [/TD]
[TD]Tue 7/10/18[/TD]
[TD]Tue 7/24/18[/TD]
[TD]9[/TD]
[TD]19%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]1.1[/TD]
[TD]Need development[/TD]
[TD]Erik[/TD]
[TD]Tue 7/10/18[/TD]
[TD]Thu 7/19/18[/TD]
[TD]9[/TD]
[TD]93%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]1.1.1[/TD]
[TD]Reviews and Ratings[/TD]
[TD]Ozge[/TD]
[TD]Tue 7/10/18[/TD]
[TD]Thu 7/19/18[/TD]
[TD]9[/TD]
[TD]100%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1.1.2[/TD]
[TD]Consumer Focus Group Testing[/TD]
[TD]Erik[/TD]
[TD]Tue 7/10/18[/TD]
[TD]Thu 7/19/18[/TD]
[TD]9[/TD]
[TD]100%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1.1.2.1[/TD]
[TD]Contracting firm for Focus Group Testing[/TD]
[TD]Julia[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Thu 7/19/18[/TD]
[TD]3[/TD]
[TD]100%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1.1.2.2[/TD]
[TD]Develop testing format[/TD]
[TD]Julia[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Thu 7/19/18[/TD]
[TD]3[/TD]
[TD]70%[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1.2[/TD]
[TD]Product Concept[/TD]
[TD]Jacob[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Tue 7/24/18[/TD]
[TD]8[/TD]
[TD]0%[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]1.3[/TD]
[TD]Region validation[/TD]
[TD]Samantha[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Tue 7/24/18[/TD]
[TD]8[/TD]
[TD]0%[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]1.4[/TD]
[TD]Certification[/TD]
[TD]Jacob[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Tue 7/24/18[/TD]
[TD]8[/TD]
[TD]0%[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]1.5[/TD]
[TD]Box replacement filters[/TD]
[TD]Jacob[/TD]
[TD]Mon 7/16/18[/TD]
[TD]Tue 7/24/18[/TD]
[TD]8[/TD]
[TD]0%[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]