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 · grouped by Team · live
Scanned 24,310 rows across 4 sheetsran in 1.2s
Team
Open
Sum effort
Avg days
Engineering
312
1,840h
4.2
Design
96
410h
2.8
QA
141
620h
3.1
Marketing
73
280h
5.0
All teams
622
3,150h
3.8

One report, four source sheets. Grouped, summed and averaged, and pulled live every time someone opens it.

Cross-sheet by design

Point one report at many sheets

Aim 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 source sheets say right now.

Live, not snapshotted
Every open re-runs against the current sheets. The total is never yesterday’s.
Survives schema drift
Delete a referenced column or a whole source and the Report self-heals on read instead of erroring. It only blocks you at edit time.
report · sources
Q3 Roadmap8,200 rows
Bugs & QA6,410 rows
Marketing plan2,900 rows
Platform backlog6,800 rows
4 sources selected24,310 rowslive on every open
Group, summarize, list

Three ways to roll the rows up

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 totals: the classic group-and-summarize report, across sheets.

Five measures
Sum, count, average, min and max. Choose one per column.
Export the flat view
Flat reports export to XLSX, scoped to the rows you can read, with a hard cap so a huge export fails loudly instead of truncating in silence.
report · measures
Group byTeam
Open tasksCOUNT
Effort (h)SUM
Days openAVG
PriorityMAX
sumcountavgminmax
Honest at scale

Too big to total? It says so.

Where some tools quietly stop counting past a row ceiling and hand you a 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 it’s truncated.

No silent caps
A run past the scan limit returns an honest message, not a number that looks complete but isn’t.
Always actionable
The message tells you exactly how to bring the run back in range.
report · run

This run is too large to total accurately

It would scan about 1.4M rows, past the 500,000-row scan limit. We’d rather say so than hand you a number that quietly stopped counting.

Drop a source so the scan covers fewer rows, and the report runs.
honest by defaultno silently-wrong totals
Scoped to the reader

The same report, scoped to each person

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.

Access-safe totals
Hidden sources are counted so the math is honest, but their names and data never leak.
One report, many truths
Share it once; every reader sees a total built only from what they can open.
report · per-viewer access
MK
Maya K.full access
4 of 4 sources
24,310 rows in the total
RC
Ravi C.contractor
2 of 4 sources
2 hiddencounted, never named
one reportscoped to each reader
Visual builder

Build it by clicking, no query language

Pick your sources, columns, grouping and measures in the Report builder. Save it and it becomes a living rollup anyone you share it with can open, and export when they need a flat copy.

No SQL, no formulas
Sources, group-by, measures and filters are all point-and-click.
Save once, share widely
A saved Report is a living view: open it any time and it re-runs fresh.
report builder
SourcesRoadmapBugs+2
Group byTeam
MeasuresCOUNTSUMAVG
FilterStatus is Open
Save reportExport XLSX
Frequently asked
Does Wisegrid have reports like Smartsheet?
Yes. A Wisegrid Report is a saved, cross-sheet roll-up that pulls rows from many source sheets and groups, summarizes, or lists them. Like a Smartsheet report it lives above individual sheets, and it re-runs live every time someone opens it instead of caching a stale snapshot.
Can I roll up data across multiple sheets in one report?
Yes, that is the core of it. Point one Report at up to 20 source sheets, map the columns that mean the same thing across them, and the engine reconciles each row at run time using those explicit bindings (never by guessing column names). You get per-group and grand totals spanning every source in a single view.
Which summary functions can a report use?
Five measures: sum, count, average, minimum, and maximum. Count works on any column, while sum, average, min, and max require a numeric column (a number column or a formula column). You choose one function per column in the builder.
Does Wisegrid support grouped reports and group-and-summarize?
Yes. You can aggregate rows into buckets with totals, list matching rows flat with filters, sort, and pagination, or take that flat list and group it by a column with per-group subtotals and a grand total. That last one is the classic group-and-summarize report, run across sheets.
Can I build a pivot table or crosstab from a report?
Yes. A Report can run in pivot mode, reshaping rows into a rows-by-columns matrix (a crosstab). It is bounded so it stays accurate: up to 200 pivot columns and a capped grid. If a pivot would exceed those limits it says so rather than rendering a partial matrix.
Do I need to write SQL or a formula to build a report?
No. The builder is point-and-click: pick your sources, the column to group by, the measures, and any filters. There is no SQL, no query language, and no helper index sheet to maintain on the side.
What happens to a report if someone deletes a column or a source sheet?
It self-heals on read. If a referenced column is deleted, or a whole source sheet goes away, that part is dropped from the run instead of erroring, and the builder shows you exactly what was dropped. It only blocks you (with a clear message) at edit time, when you are the one making the change.
Can a viewer see data in a report they are not allowed to access?
No. Every run is scoped to the person opening it. A source sheet a viewer cannot read is dropped from their run and surfaced only as a count of omitted sources, never the sheet name, its id, or any of its rows. The same saved Report shows each reader a total built only from what they can open.
What does Wisegrid do when a report is too big to total?
It tells you, instead of handing you a wrong number. A run scans up to 500,000 rows; past that ceiling the Report returns an honest "too large" message with the limit, and it points you at how to bring the run back in range (drop a source so the scan covers fewer rows). It never shows a partial total that would be wrong.
Can I export a report or email it on a schedule?
Yes to both. Any Report exports to XLSX (flat, aggregated, or pivot), scoped to the rows you can read, with a 40,000-row cap so an oversized export fails loudly instead of truncating in silence. You can also schedule a Report to email on a daily, weekly, or monthly cadence, and recipients do not need a Wisegrid seat (plain email addresses, each with a working unsubscribe link).
Do I need a special plan to build reports?
No. Building and editing Reports is included in the one Wisegrid plan ($19 per editor per month), and so is scheduled email delivery. Viewing, running, and exporting a Report someone shares with you is free for view-only collaborators, so anyone you share with can open and use a Report you built without a paid seat.

Try it on your sheets.

Start your 7-day free trial, no credit card required, or migrate your Smartsheet workspace with one token.