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%)

WBS	Task	Lead	Start	End	Cal. Days	% Done	Work Days
1	Product Development		Tue 7/10/18	Tue 7/24/18	9	19%	8
1.1	Need development	Erik	Tue 7/10/18	Thu 7/19/18	9	93%	8
1.1.1	Reviews and Ratings	Ozge	Tue 7/10/18	Thu 7/19/18	9	100%
1.1.2	Consumer Focus Group Testing	Erik	Tue 7/10/18	Thu 7/19/18	9	100%
1.1.2.1	Contracting firm for Focus Group Testing	Julia	Mon 7/16/18	Thu 7/19/18	3	100%
1.1.2.2	Develop testing format	Julia	Mon 7/16/18	Thu 7/19/18	3	70%
1.2	Product Concept	Jacob	Mon 7/16/18	Tue 7/24/18	8	0%	7
1.3	Region validation	Samantha	Mon 7/16/18	Tue 7/24/18	8	0%	7
1.4	Certification	Jacob	Mon 7/16/18	Tue 7/24/18	8	0%	7
1.5	Box replacement filters	Jacob	Mon 7/16/18	Tue 7/24/18	8	0%	7

<colgroup><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>