How can I combine grid data and Sheet Summary fields into one editable grid sheet?

E. Bradley

I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields.

I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more easily.

I understand that I can use cell linking to bring in grid data from other sheets, but when I try this, I can only link to the grid rows, not the Sheet Summary fields.

What’s the best way to create a single, formatable grid sheet that includes:

• All 48 cases (one row per case),
• The grid data from each source sheet, and
• The Sheet Summary data (like totals, owners, or other summary metrics) — ideally staying live and linked?

Paul Perger

Getting the information to one sheet sounds like a perfect job for Datamesh. That would be one large Mesh to gather information into one place, but it would work. The only downside I see would be you would have to do another Datamesh to bring data back to the source sheets if you made changes on the destination sheet. Mesh also isn't a "Live" data transfer, your meshes could be scheduled to run every hour so data would be fairly fresh automatically, but it wouldn't be live.