Project completion T-minus date
Hello - Thank you in advance
Requesting a column formula in my project sheet.
I have a "Project completion" date as well as tasks that work back by week (can be days if easier). I would like to be able to enter any "Project completion" date and ensure the tasks change based on that date.
IE: Project completion is August 12th and Task A has to be completed 4 weeks earlier I would like the task to show a start date of September 12th (or 30 days earlier)
Best Answer
-
I would suggest relocating to a sheet summary field so that you can make it a column formula.
When using a number of days, it is a simple subtraction.
=[Launch Date]# - [T-Days]@row
Answers
-
Are you able to provide a screenshot for context? Do you have a column to indicate when the task needs to be completed in relation to the project end date?
-
-
Yes thank you
To clarify:
I have project COMPLETION date and would like to work backwards to individual subtasks either by week or by day (I created a column for both)
- LAUNCH is 8/1
- Subtask 1 occurs 32 weeks before that (or 128 days)
- I would want to put that formula in the "start" column and make it a column formula since i have a lot of tasks
- I could relocate the Launch date if this causes an issue since its in the same column
-
I would suggest relocating to a sheet summary field so that you can make it a column formula.
When using a number of days, it is a simple subtraction.
=[Launch Date]# - [T-Days]@row
-
Paul Thank you that worked
I knew it was simple enough but needed that extra help!
Help Article Resources
Categories
Check out the Formula Handbook template!