Project Dates and Coming in on time

Janelle Carrier

Hi, I'm trying to set up a project template using a Gantt chart so that when the Certificate of Occupancy date is plugged in, it will automatically populate the goal dates for all the tasks prior, based on how long those tasks take, in order to be ready for the CO date. For example, if I know that a permit takes 2 weeks to obtain and the contract dictates that I must have the permit in hand 1 month prior to CO, then my start date for the permit needs to be 8/15 and the end date needs to be 9/1, assuming with a 1 month lag. That will allow for the the permit to be completed one month prior to the 10/1 CO date.

I want to populate the CO date and have the permit date automatically populate that it has to be done by this time in order to meet your CO date.

I'm probably over-complicating this explanation, I know.

TIA for any help!

Stefan

Hi @Janelle Carrier,

regarding T-minus I see no problem in using predecessors to achieve what you are describing above. If I understand ok, you've got a clear step-by-step procedure with known duration for the tasks. If you set this up once, connect the tasks via predecessor links and enter the T date first, you will get your plan updated accordingly.

Anyway, glad you found a template that helps you!

Greetings

Stefan

Stefan

Hi @Janelle Carrier,

you need to use predecessor's in your sheet.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Hope this helps

Stefan

Janelle Carrier

Thanks Stefan, I was really looking for more of a T-minus scenario, which I think I found a template for that. Thanks for responding!

Stefan

Hi @Janelle Carrier,

regarding T-minus I see no problem in using predecessors to achieve what you are describing above. If I understand ok, you've got a clear step-by-step procedure with known duration for the tasks. If you set this up once, connect the tasks via predecessor links and enter the T date first, you will get your plan updated accordingly.

Anyway, glad you found a template that helps you!

Greetings

Stefan