Reports

Roll up every sheet at once — and trust the number.

A Report pulls rows from many sheets and groups, summarizes, or lists them in real time. It stays correct at scale, tells you the truth when a run is too big, and only ever counts the sheets the person reading it can actually see.

Open work · across 6 sheets
Design12
Engineering28
QA7
Marketing9
Grouped, summarized, live — over every sheet you can read.
How it works
Cross-sheet by design
Point a Report at as many sheets as you like across a project. It pulls live on every open — never a stale snapshot — so the rollup always reflects what the underlying sheets say right now.
Group, summarize, or list
Three modes. Aggregate into buckets with sum, count, average, min, and max. List matching rows flat with filters, sort, and pagination. Or group the flat rows with per-group and grand-total summaries — the classic group-and-summarize report, across sheets.
Honest at scale
Where some tools silently stop counting past a row ceiling and hand you a quietly-wrong total, a Wisegrid Report tells you plainly when a run exceeds its scan limit instead of returning a number you can't trust. A truncated result says so.
Scoped to the reader
A Report only aggregates the sheets the person opening it is allowed to read. A source they can't access is dropped from the run and surfaced as a count — never its name, never its data. The same Report shows different people exactly what they're entitled to see.
Survives schema drift
Delete a column a Report referenced, or a whole source sheet, and the Report self-heals on read instead of erroring — dropping the dangling piece and carrying on. It only blocks you at edit time, when you're the one making the change.
Export the flat view
Flat reports export to XLSX, scoped to the rows you can read, with a clear cap so an enormous export fails loudly rather than truncating in silence.
Built in a visual builder
Pick your sources, columns, grouping, and measures in the Report builder — no query language. Save it and it becomes a living rollup anyone you share it with can open.

Try it on your sheets.

Start free, or migrate your Smartsheet workspace in minutes.