Dynamic dates
I just read and commented on a question on dynamic dates from 2018. Hoping this has since been added to the product
I have an immediate need to have all related dates update when I change the dates of of tasks and dependencies.
Example, Milestone 1 will be delayed by 1 week, so I update the due date to 1 week later. I need for the dependent dates of all impacted other milestones and tasks to be automatically updated to be pushed out by 1 week.
Best,
Jody
Answers
-
Hi @Jody Odom
If all of the following dates are dependent, linking up to this top milestone, then when you adjust the date for this milestone task it will automatically push out all of the following dates that are dependent on it.
Here are two screen captures of an example sheet with Dependencies.
1. Original date with Milestone on the 13th. Tasks 2 is dependent on the Milestone (row 2) and Task 3 is dependent on Task 2 (row 3).
2 . This means that when I change the Milestone date to 20th of Nov instead of the 13th, the following tasks adjust automatically:
You can read more about dependencies in our Help Center article, here.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives