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!
Help Article Resources
Check out the Formula Handbook template!