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)

Find more posts tagged with

Accepted answers

Paul Newcome

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

All comments

Paul Newcome

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?

Morris R

Morris R

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

Paul Newcome

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

Morris R

Paul Thank you that worked

I knew it was simple enough but needed that extra help!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.