Multiple dependencies with dependent start dates

1

Hi all,

I’m trying to set up a project management system where projects can have multiple dependencies. Right now the start dates of projects are equal to the end dates of projects they depend upon, unless they are starting project in which case their start date is the “Work Start Date”. I know there must be a way to set up a formula so that its start date is whichever end date of a project it depends upon is the latest, but I can’t figure that one out.

See this for an example: I want “Do Full Rollout” to depend both on “translate content” and “plan communications”. At this point, if “plan communications” took longer than expected I’d have to manually change the dependency for “Do full rollout” to go onto that project.

[quote=“Tim_Richardson1, post:1, topic:13019, full:true”]
Hi all,

I’m trying to set up a project management system where projects can have multiple dependencies. Right now the start dates of projects are equal to the end dates of projects they depend upon, unless they are starting project in which case their start date is the “Work Start Date”. I know there must be a way to set up a formula so that its start date is whichever end date of a project it depends upon is the latest, but I can’t figure that one out.

See this for an example: I want “Do Full Rollout” to depend both on “translate content” and “plan communications”. At this point, if “plan communications” took longer than expected I’d have to manually change the dependency for “Do full rollout” to go onto that project.

2

Hi @Tim_Richardson1

I don’t know how you set up the dependencies, but maybe you can select more than one “depend upon” project for each dependent project and then set the start date to something like [depend upon].filter([end date].max).[end date] (I’m not in front of my computer so I’m not sure about the syntax)

*The doc in the link is not accessible, you need to set the sharing options to “everyone with the link can view” or, better, embed it here with the “enable play” on.

1 Like
3

Fixed the embed, thanks!