Gantt Chart Start Date with Dependencies
I have a gantt chart that maps out a long process. I want row 1 to be a start date (and finish and duration). But I can't enter the start date there because there are dependencies to this start date. Rows 2-4 are sub tasks, meaning row 2 is "Phase 1", then rows 3 and 4 are subtasks of Phase 1. I can only enter a start date on row 4 because that is the first sub-task that rolls up to the start date in Row 1. It's not intuitive for the user to enter a start date on row 4 when row 1 looks like the overall project schedule. I tried entering 1SS in row 4 and it creates a circular dependancy. But if I take away the dependency on row 1 I lose all of the duration and finish date information. Anyone have wisdom on how to make this dependency/start date work like it should?
Help Article Resources
Check out the Formula Handbook template!