Project Plan Dependencies Formula

[treeleaf20]

I have a project plan that works fine. I'd like to add a column for dependency and the date would be updated based on the finish date of the row id that is entered. Any suggestions on if this is possible?

 

[sykes]

Can you explain a little more, what's required? May be me being thick, but I can't work out what you want...

 

[treeleaf20]

Sure. I have a start date in column I and a finish date in column J. In column H I have a dependency and then in column A I have an ID. Basically what I'd like to do is if someone enters in a dependency in column H (could be a comma separated list), I'd like to find the latest finish date from the list and then for the row the dependency was entered on I'd like update the start date to be the next working day.

For example, see below:

ID	Dependency	Start	Finish
1		07/01/2019	07/12/2019
2		07/04/2019	07/09/2019
3		07/09/2019	07/11/2019
4	1,2,3	07/15/2019	07/16/2019

<tbody>
</tbody>

You can see that the start date would be updated to the next working date from the latest finish date determined from the list of dependencies.

Thanks!

 

[sykes]

... so, if I understand your scenario correctly, someone has entered "1,2,3" as a dependency, into the row for ID4.
Shouldn't the Start date for ID4 now show "07/17/2019" - as the latest Finish date in your example is 07/16/2019, and you want to display the date of the next working day?
Why's it showing 07/15/2019?

 

[treeleaf20]

I only want it to calculate the start date for the row that has the dependency. So in this example it would find that the finish date of the rows that are dependencies is 7/12/2019. The next working day is 7/15/2019 so that would populate the start date to be 7/15/2019 and then the finish date is a formula as well that is calculated by another row not seen here since I just need the start date calculated.

 

[Marcelo Branco]

Maybe this...

Formula in C5
=IF(B5="","",WORKDAY(AGGREGATE(14,6,D$2:D4/ISNUMBER(SEARCH(A$2:A4,B5)),1),1))

M.