Weekend Workaround in Gantt Charts?
Has anyone found a workaround for not being able to pull dependancies from a separate sheet? I have projects running where some tasks are "in office" (5 day work week) and some tasks are "in field" (7 day work week). Gantt settings only permits setting work weeks for an entire sheet, so I have pulled those two types of tasks into two separate sheets.
The problem is that these tasks need to link dependancies. We can't start some tasks in the field until the office work is complete. My theories of solution are:
-An automation to push over the Office Sheet completion line to the field sheet.
-Add a column to the Field Sheet that references the Office sheet.
-Put all dates in a 7 day schedule and add in dummy weekends.
Thank you all for the collaboration.
Help Article Resources
Check out the Formula Handbook template!