Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is it possible to Auto-Fill dates?
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
Comments
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives