How can I create one master Sheet from multiple sub-Sheets?

Torre

I have a large program that spans several years and consists of ~10 teams. I would like each team to be able to create their own project plans (Gantt and Timeline views needed) and link tasks between teams as needed. So each team should have their own Sheet. I understand how to use the Cell Linking feature for the links between teams' Sheets - so that part is working for me. However, I would like to be able to merge all of these teams' sheets into one Master Sheet so that I can look at the entire programs plan (both in Gantt and Timeline views). So creating a Report won't work because I want the Timeline View. How can I make this work?

Naeem Ejaz

You're right — Reports in Smartsheet allow aggregation and filtering of data across multiple sheets, but they do not support Gantt or Timeline views, which makes them less ideal for your use case of program-wide timeline visualization.

To achieve a consolidated Gantt/Timeline view across multiple teams and sheets, here are your best options:

✅ Option 1: Use a Master Sheet with Cross-Sheet References or Data Shuttle

🧩 Overview:

• Keep each team working in their own sheet.
• Use cross-sheet formulas or Data Shuttle (Enterprise) to roll up their project tasks into a Master Program Sheet.
• The Master Sheet will be the only place where you enable Gantt/Timeline View.

✅ Benefits:

• Teams stay autonomous.
• You maintain a single source of truth at the program level with Gantt capabilities.

🔧 How to do it:

1. Create a Master Program Sheet with consistent column structure (Start Date, End Date, Task Name, etc.).
2. For each row in the master:
   • Use cell linking OR
   • Use cross-sheet formulas (like =INDEX(COLLECT(...))) to pull task data from each team’s sheet.
   • Alternatively, use Data Shuttle to schedule regular imports of data from team sheets.
3. Ensure dependencies and date columns are properly set up in the master for the Gantt chart.
4. Use Hierarchy (indentation) and Predecessor columns in the master to reflect program structure and dependencies.

⚙️ Option 2: Use Control Center (if available in your plan)

If you're on an Enterprise Plan with Smartsheet Advance, you may have access to Smartsheet Control Center.

• This allows you to:
  • Create consistent project templates for each team.
  • Automatically generate new project sheets.
  • Create program-level rollup sheets that consolidate data across projects.
  • Maintain Gantt or Timeline view in the master rollup sheet.

Andrée Starå

https://community.smartsheet.com/discussion/140066/how-can-i-create-one-master-sheet-from-multiple-sub-sheets

Hi,

I hope you're well and safe!

This sounds like a perfect use case for the Premium App, Control Center.

Do you have access to it, or is it an option to add?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Torre

Unfortunately I don't have access to the Premium apps. I am attempting the Cell Linking but it loses the predecessor connections so I don't see those dependencies in the Master sheet gantt chart.