With a report, you can compile information from multiple sheets and show only items that meet the criteria you specify. You can consolidate key tasks and milestones into an overview for stakeholders, or create different views for various initiatives.
Similar to a sheet, a report can be sent, shared, and published. You can also edit, group, summarize, and sort data in a report. Note that a report is different from a sheet because no information is stored within it (instead, it displays information stored in sheets). Because of this difference, reports don't count against the sheet limit for your account.
Reports are bi-directional, so information updated on a report will automatically update back to the underlying sheets and vice versa. Use grouping and summary in reports for quick and easy aggregation and calculation across data from multiple sheets.
Reports can be shared with anyone who is also shared to the underlying sheets populating the report. Publish your report, or display it in a dashboard to ensure your audience only sees the high-level information you want to display—without requiring your audience is shared to the underlying data.
There are two types of reports available - Row Reports and Sheet Summary Reports.
With Row Reports, you can aggregate row information from multiple sheets. For example, you can create a report to see all your high-priority incomplete tasks, pulled from multiple sheets.
See Build a Row Report with Report Builder to learn more.
Sheet Summary Reports
With Sheet Summary Reports, you can display summary data from multiple sheets. Sheet summary reports are a great way to get a high-level overview of multiple projects or to highlight portfolio-level metrics in a dashboard. These reports aggregate sheet summary fields from one or more sheets into a single report to surface key metrics based on report criteria.
Information can be combined into groups and summarized using functions to calculate totals on report columns.
Reports can be added directly to a dashboard or visualized in a chart to communicate real-time progress to stakeholders.
See Create a Portfolio View With a Sheet Summary Report for more on building a sheet summary report.