2 issues
How to cross-link dependencies between separate project management sheets
How to see these cross-link dependencies in a summary sheet
I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management
https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt
https://www.smartsheet.com/comment/34120
http://help.smartsheet.com/customer/portal/articles/765753-parent-rollup-functionality
In conclusion, I thought the best way was to create a master project sheet and then cell-link the rows of the master to individual project sheets, a more top-down approach than the sites listed. It's simpler this way to set dependencies between different projects.
However, creating a cell-link between the individual sheets to a master sheet will cause my resource viewer to state that all of my resources are over-booked.
Is there a way to turn-off the resource for the master/summary sheet?
Is there a way to show cross-linked depenencies if I do the "bottom-up" approach as suggested by the sites?