Project Plan with successor and predecessor dates

[armour919]

Good day,

Building out a project plan trying to pull in predecessor dates to the successor. I wrote a formula to count the "." in the task #. I wanted to pull the max end date of the successors of the predecessors. So for 1.9's end date would like to receive the end date for 1.9.1. The issue I face is writing something that looks at them in sections and not pull in the dates of the next set of successors tied to another predecessor. Any help? preferred not to write any VBA

[TABLE="width: 782"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]#[/TD]
[TD]Task[/TD]
[TD]Lead[/TD]
[TD]Successor>1[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Days[/TD]
[TD]% complete[/TD]
[/TR]
[TR]
[TD]1.8[/TD]
[TD]Training for Information Steward for MDM team[/TD]
[TD]Kris[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.9[/TD]
[TD]Compile findings to Identify what data meets that criteria[/TD]
[TD]Sonia[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.9.1[/TD]
[TD]Create rules in " Information Steward"[/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.10[/TD]
[TD]Excute the Information Steward data profiling[/TD]
[TD]Sonia[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.11[/TD]
[TD]Business reviews the output of the profiled data and identifies the cleansing tasks [/TD]
[TD]Data Steward[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.12[/TD]
[TD]Develop an plan to terminate drivers: [/TD]
[TD]Sonia[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.12.1[/TD]
[TD]Request to IT/Business cleanse the data [/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.12.2[/TD]
[TD]Testing on QA2 [/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.12.3[/TD]
[TD]Move to production[/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.13[/TD]
[TD]Perform QA the Information Steward profiling, validate results[/TD]
[TD]Sonia[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.14[/TD]
[TD]Continuation of data cleansing:[/TD]
[TD]Sonia[/TD]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.14.1[/TD]
[TD]Business requests to terminate [/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]1.14.2[/TD]
[TD]Develops program to terminate in all places, not just FM (or build pgm earlier in step so the business can clean their own data) [/TD]
[TD]Sonia[/TD]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD] - [/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Twollaston]

Hey there, I was having trouble understanding what exactly you are requesting. I'm not sure what predecessor date you are referring to. Can you explain it differrently and possibly show what you want it to show when it's working correctly

 

[armour919]

I do not have end dates added yet but it would be added to the sheets.

Looking at 1.12 Develop a plan to terminate drivers, I would like to have it look at all the successors below, 1.12.1 - 1.12.3 and pull the max end date to the end date of 1.12 but not the dates for 1.13 or 1.14 and their successors of 1.14.1 & 1.14.2. Hope that makes more sense.