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!
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
Thanks Sheri! I am going to play with this idea and see if I can get it to work for them.
Views
Likes
Replies
Views
Likes
Replies