Multiple Projects - Resource Overview

Hi,

we are using Smartsheet for managing our Sales Pipeline. As soon as a project is ordered, we are using the same line to gather project information related to execution. I would like to add a Gantt Chart to each lien (via Hyperlink to another Smartsheet) in one cell with resources.

Question: I would like to see a summary of all my Gantt cahrts and resource allocation in an overview. Can anyone advise? I thought this would be able in resource view. But there I see no  difference between project and user view.

Best Marco