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
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!