Report or Master Sheet with all the main tasks from multiple sheets to view on Gantt

pyou

I have multiple sheets, one per product. Each sheets will have timelines for different tasks. How can I put together a Report or master Sheet with all the Tasks from across the Product sheets? I want to see all the timelines, for the main tasks, on 1 Gantt.

Jason Hamman

You can do this using a Report and selecting Gantt View.

IMPORTANT: The columns used to setup the Gantt (Start date column, End date column, and % Complete column) must have the same names in each source sheet.

pyou

Hi Jason, I've done this, but the report is unwieldy. Is there a way to just have the Task timelines and not the subtasks?