I was trying to do this on Smartsheet but it will only create a gantt chart for a specific opportunity or account, etc.

How do you create a gantt chart that displays multiple opportunities? Essentially linking fields such as Opportunity Name, Start Date, Finish Date and % Complete of multiple opportunities in one gantt chart to show an operations schedule.