How do I set dates in a project schedule that automatically update when a prerequisite is met?
I am putting together a phase schedule for a project I'm on. We are currently in the "awaiting deliverables" stage, and we have preset 'assumed' start and end dates for all the tasks in each of the phases when we officially begin work on the project. I need to somehow set up the schedule that if deliverables arrive earlier/later, Smartsheet will automatically shift all the dates in the schedule accordingly (rather than having to change them manually). We want the Gantt chart to flow nicely as well. I plan to implement dependencies and predecessors, but I need a formula that brings this all together nicely. Thanks!
Answers
-
If you have set up predecessors for all of your tasks then they will automatically shift if the start/end date changes. As soon as you turn on dependencies you can no longer input formulas into your start/end date columns as they will be used in the calculation for duration & predecessor.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!