Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Gantt Sheet - Linking Dates

How can I generate the sub dates on a Gantt sheet using the duration?
I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration.Β
For exampleΒ
If the Head start date is 1/3/2016Β
I would like the sub dates to auto generate from the duration ifΒ
Project line 1 was 1d duration pre head start date it would read 29/02/2016
project line 2 was 2d duration post head start date it would read 3/03/2016
Β
I have a master sheet with the durations for each sub but this does not auto amend when I copy the project and change the head start date.
Β
thanksΒ
Β
Comments
-
Kevin,
Β
Make sure Dependencies are turned on (in the Project Settings).
Β
You can't work backwards from a Summary Row start date in a child on the summary.
That defeats the purpose of the Summary Row.
Β
However, if you are tying to another task, you have 4 possibilities for Predecessor type:
Β
SF - start to finish, the second task can't start until the first finishes.
SS - start to start, the second task can't start until the first starts
FF - finish to finish, the second can't finish until the first finishes
FS - finish to start, the second can't finish until the first starts
Β
If Task B starts 2 days before Task A, then SS is what you are looking for and using a lead/lag
Β
1SS - 2d
Β
(if Task A is in row 1)
Β
might get you what you want.
Β
Craig
Β
Β
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives