What we do
Tools
Industries
Department
How we workLet's talk →
Home/Smartsheet/Smartsheet Dashboard
Smartsheet

How to Build a Smartsheet Dashboard, and the Report That Feeds It

A Smartsheet dashboard is a page of widgets: charts, metrics, reports, text and links. The widgets read from sheets or reports, so a good dashboard usually starts with a report that pulls rows from every sheet you care about. Here are the clicks, a full build, and the snags that stop a widget from showing up.

Create a dashboard

Make it: on Home, select + Create on the left rail, choose Dashboard, pick where to save it and name it.

+ Create Dashboard

Add a widget: select the pencil to edit, then the plus to add widgets. Choose Chart, Metric, Report, Timeline, Title, Rich text, Image, Shortcut or Web content.

Edit (pencil) Add widgets (+)

Point it at data: charts read from a sheet or report, metrics from cells in a sheet, report widgets from a saved report. Select Save at the top right when you're done.

Build a dashboard across several project sheets

The example most people need: one screen showing every active project's status, with the late tasks listed.

  1. 1

    Build a row report across the project sheets

    + Create Report Row Report

    Name it and open the Report Builder. Under Sheets, pick each project sheet, or a whole folder or workspace so new projects are included automatically. Under Columns, choose the ones the dashboard needs, such as task, owner, status and due date.

    Watch for: Report Builder options that stay grayed out until at least one sheet, folder or workspace is picked.

  2. 2

    Filter the report to what matters

    In Filter Criteria, keep only open tasks, or tasks past their due date. Group by project or status if you want the report to read as a summary rather than a list.

  3. 3

    Keep the headline numbers in one place

    For the big numbers at the top, keep totals such as projects at risk or tasks overdue in cells of one sheet, worked out with formulas. A metric widget reads those cells directly.

  4. 4

    Create the dashboard and add the widgets

    + Create Dashboard

    Add a metric widget for the headline numbers, a chart widget for status by project from the report, and a report widget listing the late tasks. Arrange them, then save.

    Watch for: Permission levels: at least Editor on the source for chart and metric widgets, and Admin on the report for a report widget.

  5. 5

    Share it

    Share the dashboard with the people who need it. Viewers on a dashboard don't always need access to the sheets behind a report widget to see its content, which is handy for leadership.

Smartsheet report or dashboard: which one to build

Report

Rows from many sheets, one grid

  • A filtered, combined list of rows from one or more sheets.
  • You can edit the rows in the report and the change lands in the source sheet.
  • Best for people who work the list: assign, update, close.
Dashboard

A one-screen picture for people who glance

  • Widgets laid out on a page, from charts and metrics to text and links.
  • Usually built on top of reports, so it stays current as rows change.
  • Best for project leads and leadership who won't open a sheet.

You usually need both. Build the report first, since it decides what data appears, then put it on a dashboard for the people who only want the picture.

When a Smartsheet dashboard widget misbehaves

A column in the report shows "(column not found)"

How you'll know: Blank columns in the report, and blank values in any widget built on it.

Fix: Someone renamed the column in a source sheet. Open the Report Builder, add the column under its new name and remove the old one.

You can't pick the report for a report widget

How you'll know: The report doesn't appear, or can't be selected, when you add the widget.

Fix: You need Admin access on the report. Ask its owner to raise your sharing level.

The dashboard stops letting you add widgets

How you'll know: An error and an upgrade prompt when you add one more.

Fix: On the Pro plan a dashboard holds up to 10 widgets. Combine metrics into one widget, split the dashboard in two, or move to Business.

New projects never show up

How you'll know: The dashboard looks right but misses this month's new project sheets.

Fix: The report was built on named sheets. Rebuild it on the folder or workspace the projects live in.

Putting numbers from outside Smartsheet on the dashboard

Widgets only read from Smartsheet, so a dashboard can't show margin from your accounting system or ticket counts from your help desk on its own. If the other system can export a file on a schedule, Smartsheet's Data Shuttle, where your plan includes it, can load that file into a sheet that a widget then reads. A Web content widget can also embed a chart from another tool, such as Tableau.

When neither fits, because the other system doesn't export files or the numbers need to be current, the answer is the Smartsheet API. n-frames builds that feed: profit per job from QuickBooks or ticket volume from your support tool written into a sheet on a schedule, so the dashboard's metric and chart widgets show the whole business. For a team that's outgrown the dashboard, we build the same view outside Smartsheet entirely.

Questions people ask

Does Smartsheet have dashboards?

Yes. Smartsheet dashboards lay out widgets, such as charts, metrics, reports and timelines, on one live page. They're common for project status and leadership summaries.

How do I create a report across multiple sheets in Smartsheet?

Select + Create, then Report, then Row Report. In the Report Builder, pick the sheets, or a folder or workspace, then the columns and filter criteria. The report combines matching rows from all of them.

Can a Smartsheet dashboard show data from outside Smartsheet?

Not directly. Widgets read from sheets and reports. You can load outside data into a sheet first, with Data Shuttle if your plan includes it or through the API, or embed another tool's chart with a Web content widget.

What's the difference between a Smartsheet report and a dashboard?

A report is a filtered list of rows from one or more sheets, which you can edit. A dashboard is a page of widgets for viewing at a glance, often with a report or chart of a report on it.

How many widgets can a Smartsheet dashboard have?

On the Pro plan, up to 10 per dashboard. Adding an eleventh brings up an error and an upgrade prompt.

Who can see a Smartsheet dashboard?

Anyone you share it with. Viewers are free on Smartsheet plans, and for report widgets, people shared to the dashboard don't always need access to the underlying sheets.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.