Gantt rollup for multiple projects

edited 12/09/19 in Smartsheet Basics

We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency column link from the metric and project sheets but as soon as I enabled dependencies the system erased it and locked the cell. 

Attached are a couple of screen shots of a live project gantt, template project metric sheets, template project sheet and the live overall rollup for your reference. 



SS-Gantt Rollup-Live Project Sheet.PNG

SS-Gantt Rollup-All Project Rollup.PNG

SS-Gantt Rollup-Project Template Sheet.PNG

SS-Gantt Rollup-Project Metric Sheet.PNG