Multiple dependencies
Hi,
I have an issue that I'm not able to solve:
In this example I tried to define the beginning and the end of task 3 to be dependent on task 1 and task 2, respectively.
I want Task 3 to start when task 1 starts, and for the end of the event “finish-finish” with task 2.
As you can see, it automatically sets the correct end date. But the duration is set to 1d and does not start at the correct start date.
I want it to look like this:
So if task 1 or 2 have any changes, this will affect the duration of task 3).
Thanks!
Answers
-
Hi @Daniel Kumar ,
I hope you are good and safe..
My suggestion you can cell reference like "=(represent the task 1cell) and give enter, it will take automatically the task1 start date, similarly for end date of task 3 also.
Thanks,
Sandhiya P
-
Hi Sandhiya,
Could you send a screenshot on how you would do it?
Just to make sure I get your idea.
Best,
Daniel
-
Kindly refer the below screenshot,
You can use the same for column 3(i;e end task in your scenario)
Thanks,
Sandhiya P
-
Thanks for the screenshot. This can be a way to solve this!
I tried to to this, but its seems like i cannot do this since these columns are formatted as a start date and end date column.
Best,
Daniel
Help Article Resources
Categories
Check out the Formula Handbook template!