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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!