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
