Yodelayheewho
Member
Hello!
Attached is a file titled: Test WBS. The first tab, 2019 Projects, shows a very detailed list of projects in WBS format. The challenge I have is reporting projects back to our VP, who does not need, or want, to see every detail.
In the 2019 Projects sheet, I've indicated in Column D (VP View) those items I need the VP to see; marked with 'X's'. I've created a second tab, VP View. My goal is to have all of the rows with 'X's' from 2019 Projects show up on VP View (minus the gantt chart). I would like to retain the WBS hierarchy in the VP View, so it would like something like this...
1 Project 1
1.2.2 Email - Deploy
1.4.2 Live Webinar - Internal ONLY
1 Project 2
2.2.2 Email Save-The-Date - Deploy
2.2.3 Email with download instructions - Deploy
1.4.2 Live Webinar
3 Project 3
3.2 Assessment Worksheets to SD's
3.3 Assessment Worksheets back from SD's
3.4 MBR to SD's
3.5 MBR back from SD's
3.6 Monthly Totem Poles
3.6.1 Product 1
3.6.2 Product 2
3.6.3 Product 3
3.7 Monthly Department Report
3.7.1 Monthly Report to SOP
3.7.2 Monthly Report to SD's
3.7.3 Monthly Report to All
4 Project 4
4.2.2 Draft 1: to Team
4.3.4 Final Draft: to Print
Thank you in advance for your consideration!
Attached is a file titled: Test WBS. The first tab, 2019 Projects, shows a very detailed list of projects in WBS format. The challenge I have is reporting projects back to our VP, who does not need, or want, to see every detail.
In the 2019 Projects sheet, I've indicated in Column D (VP View) those items I need the VP to see; marked with 'X's'. I've created a second tab, VP View. My goal is to have all of the rows with 'X's' from 2019 Projects show up on VP View (minus the gantt chart). I would like to retain the WBS hierarchy in the VP View, so it would like something like this...
1 Project 1
1.2.2 Email - Deploy
1.4.2 Live Webinar - Internal ONLY
1 Project 2
2.2.2 Email Save-The-Date - Deploy
2.2.3 Email with download instructions - Deploy
1.4.2 Live Webinar
3 Project 3
3.2 Assessment Worksheets to SD's
3.3 Assessment Worksheets back from SD's
3.4 MBR to SD's
3.5 MBR back from SD's
3.6 Monthly Totem Poles
3.6.1 Product 1
3.6.2 Product 2
3.6.3 Product 3
3.7 Monthly Department Report
3.7.1 Monthly Report to SOP
3.7.2 Monthly Report to SD's
3.7.3 Monthly Report to All
4 Project 4
4.2.2 Draft 1: to Team
4.3.4 Final Draft: to Print
Thank you in advance for your consideration!