它是可能的to Auto-Fill dates?

PJ Smith

Hello,

I'm sorry if this question has been asked before, but I couldn't find anything through the search function...

I have prepared a template for event management. We use the same structure for every one of these specific events that we do (the event date is announced, and then we work back from the date to establish delivery guidelines).

There is one thing that I am missing: I want the ability to type in a date (even if it's in another sheet that I link), and then have my dates in the template auto-fill using that information.

Example:

- Event Date is 12-1-2015. I type that into a sheet that is a record of all of the events. (Event Schedule)

- That cell is then linked to the sheet that has all of the project deliverables/milestones for that event, and works backward from the date entered, showing that "Task A" is due 60 days prior, "Task B" is due 45 days prior, and so on.

Anyone have any idea if this is possible? I don't seem to be able to link dates to a project management SmartSheet.

I'm hoping that it is possible and I'm just not seeing it. Any help is appreciated. Thank you!

-PJS

Brett Evans

PJ,

Check out my answer in this post:

https://community.smartsheet.com/discussion/date-formula-help

If you use the increment variable/column to modify days instead of months then you should be able to do it. One caveat, you are going to have to calculate if the years change as well as the month.

-brett

BobbyLite

Predecessors can be used to do this as well.Link all your tasks together with predecessors then add lag/negative lag days where needed (-60 days, -45 days, etc). Then all you need to do is add your first task date and all the other dates will automatically calculate.