Floating dependency start dates
I have two dates: A and B. B's start is dependent on A's completion.
If everything goes as planned, A will finish on 2/27 and B will start on 4/1. B's start date is constant unless A's finish is delayed beyond the planned start. For example, if A is delayed until 3/15, B will still start on 4/1; but if A is delayed until 4/5, B will start on 4/6.
Is there a formula/dependency that allows me to set this relationship?
Thanks.
Tags:
Answers
-
@SSuser37 Add another task that is a milestone set for April 1.
- Insert it just before B for convenience;
- Call it "B Earliest Start", and
- Tie B to that task AND to task A.
- The start date for B should be the latest of "B Earliest Start" and task "A".
dm
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives