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.
Answers
-
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.
-
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?
