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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!