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.
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.