Template Task Start Date dependant on Project Completion Date

Question

Hi. I am trying to help a user set up a template and I am not sure how to accomplish what they need.

Schedule Mode = Completion Date

All tasks will work backwards from set Completion Date. They would like to be able to set the Task Start Dates on the template to be X number of days from Completion Date. So Task 1 needs to start 4 weeks prior to Completion Date, Task 2 needs to start 3 weeks from Completion Date, Task 3 needs to start 5 days prior to Completion Date etc...

Do I need to enter a formula to make this work? Is there a simple solution I am overlooking? Thank you!

Sheri_Whitten · Accepted Answer

I remember our events team wanted this same thing and we were advised to have the first task in the template be the show date (or in your case the completion date), then use predecessors with lag, to work back from that date, to calculate the task dates (using Schedule Mode - Start Date). Here's an example:

This may be helpful: Overview of Lag Types

I've never successfully used completion mode scheduling, it's always caused unintended consequences for us 😕😕

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded