Smartsheet sheets vs reports vs dashboards: what to use

What is the difference between a sheet, report and dashboard?

These layers can work together. You do not need to copy every task into a second tracker to give a manager a different view. Smartsheet’s platform overview describes project views, reporting and automation as parts of its work management system. This guide reviews the reporting workflow on 16 October 2026; the example is fictional.

For the broader product overview, visit the Smartsheet profile. For another approach to structured work, compare Airtable and Smartsheet.

Does a Smartsheet report copy the data?

Smartsheet’s report types guide explains that reports display information held in sheets rather than storing a separate set of records. Reporting is bidirectional: permitted edits to editable data flow back to the source, and source changes appear in the report.

A row report works with task rows. A sheet summary report brings together sheet summary fields, which is useful for project-level metrics. Choose the type based on the unit you want to report: individual tasks or each project’s summary.

For a task queue, agree the source sheets, displayed columns and filter in the row report builder. Keep an identifier and a source-sheet reference visible while validating it. A row disappearing after it stops meeting the filter does not mean the source task was deleted.

Worked example: two project sheets and one overdue report

A fictional team tracks two signage projects, Site A and Site B, with the same columns. Each row below is a unique task, not a project total or parent row. The review date is 16 October 2026.

Define overdue as Status is not Complete AND Due is before 16 October 2026. Both conditions must hold. B02 is due on the review date, so it is not overdue under this rule. Completed tasks are excluded even when their due dates are earlier.

The expected result is A02 and B03. Keep the review date fixed when reconciling these files. A real report using a relative date must be checked at the actual date and environment settings; the downloaded example does not advance with the calendar.

What should the dashboard show?

The dashboard overview describes a visual hub built from widgets. For this example, propose a task summary, the overdue queue and a link back to each source. Agree the meaning of every number before choosing a chart.

Two complete plus four open equals six tasks. The two overdue tasks are already inside the four open tasks; adding them again would double-count them. These are task counts, not hours, project completion percentages or evidence that either project is ready to launch.

As a controlled planning check, change B03’s due date from 14 to 18 October in a test copy. The overdue report should then contain A02 only, while the open count stays four. The task still exists and remains Blocked; moving its due date has not resolved the blocker. No Smartsheet account or dashboard was operated to produce these expected results.

Why is a shared report blank or missing rows?

Sharing a report does not grant access to its source sheets. A person opening it directly sees data from the sources they can access. Someone with access to Site A but not Site B may see A02 and miss B03, even though the report owner can see both.

Check the selected sources, filter, report sharing and source sharing before treating a partial view as the whole queue. Test with the intended viewer, rather than only the owner. Hiding columns or selecting a few rows in a report is not evidence that a person cannot open other data through their underlying sheet access.

Write down the audience and the information they need. Then choose an authorised way to deliver it. Report sharing, dashboard presentation and a published link have different access behaviour; do not substitute one for another without reviewing the actual settings.

Why can a dashboard viewer see something different?

A report widget has its own Viewer Mode settings. Last widget Editor uses that editor’s view and can display data from sheets the dashboard audience cannot otherwise access. Their own perspective uses the viewer’s sheet permissions; with a Current User filter, it can show that viewer’s assigned rows.

Publishing a dashboard with Their own perspective selected does not display that report widget’s data. For a blank widget, check mode and publishing context as well as source access. Agree the audience before selecting a mode.

For the fictional example, record whether each intended viewer should see both projects or only their authorised work. Also nominate a maintenance owner: changing the access of the person behind a widget can affect what it displays. Review the real widget after ownership or staff changes.

Does Smartsheet Pro include reports and dashboards?

The reviewed plan comparison includes reports and dashboards on Pro, but limits each Pro report to one source sheet and each dashboard to ten widgets. Business supports multi-sheet reporting and report grouping/summary. “Unlimited reports” is not the same as unlimited source sheets inside each report.

The two-source example therefore needs a plan that supports multi-sheet reports. Business has a minimum of three paid Members. Check the required functions and retained plan together; the 30-day trial FAQ describes a Business trial, so a feature working during evaluation does not prove it is included in Pro.

The legacy Free plan documentation says that plan is closed to new signups. Existing Free users have a different entitlement from a new trial. Account access and ongoing team-plan availability should be recorded separately.

Seat type matters too. The user model guide separates paid Members, free Contributors and eligible external Guests. An action beyond the current seat type can trigger provisional membership when the sharing permission allows it. Ask the System Admin to confirm the actual approval setting and review period. Keep a separate budget for required add-ons and setup work using the software cost checklist.

Use the reporting review before committing

The worksheet gives six proposed checks: source coverage, the overdue rule, a controlled change, direct report access, widget perspective and the retained plan. Actual results, environment details, evidence, reviewer and decisions are blank for your own evaluation.

Keep the task source, report definition and dashboard audience with the handover notes. If the reporting requirement is the reason for buying the software, reconcile the same task IDs across all three layers before relying on the headline figures. The downloads use an editorial column layout; map it to the real environment rather than treating it as a native export.

For the broader buying process, use the project management trial checklist. If you are deciding whether to keep a spreadsheet workflow, read Excel or Trello for project tracking.

Frequently asked questions