Weeks Out - Production Timeline Templates

emmacomeau

I'm trying to replicate a function that is helpful for creating production timeline templates, that I use in google docs. Column A is the due date of a task. Column B is the number of weeks out from your launch date. Column A is calculated by taking your launch date and subtracting the weeks out, to create a due date for the task.

Say your launch is Oct 15, 2019 and you want something completed 2 weeks before:

=DATE(2019,10,15)-B1*7   would be in cell A1

2  would be in cell B1, for 2 weeks out from launch 

The formula would then display A1 as 10/1/19 (two weeks before launch)

This formula is helpful if you do the same types of launches repeatedly and have similar timelines so you can make a template for production and just plug in the launch date. Does Smartsheet have a similar type of formula?

 

Thanks!

Andrée Starå

Hi Emma,

You could use the Dependencies feature instead to set this up.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

emmacomeau

Hmmm, not really. I'm looking for a way to create a template, where I plug in the launch date of a project and the due dates of each task update automatically.

emmacomeau

Ok - I figured out the formula:

 

For a task start date:

=$Start$1 - (7*[Weeks]1)

In the Start column, cell 1 is the launch date

In the Weeks column, cell 1 is the weeks out from launch the task is due.

 

For a task finish date:

=Start3 + Duration3

 

 

Andrée Starå

Great to hear that you solved it!

Best,

Andrée