Project Dates and Coming in on time
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!
Best Answer
-
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
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
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!
-
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
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!