Smartsheet Dashboards: How to Build One That Holds Up

Build a Smartsheet dashboard by preparing the data first: add sheet summary fields or a report that already holds the numbers you want, then create the dashboard from Home, select +Create, choose Dashboard, and add metric, chart and report widgets that point at that prepared source.

The data model decides whether the dashboard is buildable at all

Most guides open at the +Create button. That is the wrong place to start, and it is why so many Smartsheet dashboard projects stall halfway through.

Smartsheet’s own documentation is blunt about the constraint that shapes everything else: charts pull data from a single sheet or a report, and a chart cannot be created against data spanning multiple sheets. If your source data sits on five project sheets, you have exactly three ways to make it chartable, and you have to pick one before you place a single widget.

• Sheet summary fields. These sit alongside the grid and hold one value each — percent complete, open risk count, budget variance. The metric widget reads them directly through Sheet Summary data. This is the cleanest option for headline numbers because the calculation lives on the sheet, not inside the dashboard, so it stays correct when someone reorders rows.
• Reports. A report consolidates rows from many sheets into one queryable object. Chart and report widgets both accept a report as a source. Report grouping and summary — the feature that produces the aggregate rows a chart usually needs — is not available on the Pro plan.
• Cross-sheet formulas. Available on every paid plan. Use these to pull values from other sheets into a single roll-up sheet, then summarise that sheet. If you are new to the syntax, the Smartsheet formulas and functions reference covers cross-sheet references and the SUMIFS/COUNTIFS patterns that most roll-up sheets are built from.

The Pro plan is where this becomes a hard wall rather than an inconvenience. Smartsheet’s pricing page caps Pro at 1 sheet per report and 10 widgets per dashboard. A single-sheet report cannot roll up a portfolio, so a genuine multi-project dashboard is not achievable on Pro no matter how the widgets are arranged. If you are scoping a programme dashboard, check the plan boundary before you promise it — the current Smartsheet plan and pricing breakdown sets out where those caps sit.

The practical sequence: build the roll-up sheet, add the summary fields, build the report, confirm the numbers are right in the report itself, and only then open the dashboard. If a number is wrong on the sheet, no widget configuration will save it.

Create the dashboard

1. On the Home screen, select +Create on the left rail.
2. Select Dashboard, then choose where to save it. Save it into the same workspace as its source sheets — this makes permissions inherit sensibly instead of forcing you to share every item individually later.
3. Type a name for the dashboard and select OK.
4. The Dashboard Builder opens with two options: describe what you want in the prompt box, or select Build dashboard manually for a blank canvas. The AI route asks you to select up to five sheets as data sources and proposes charts; the manual route gives you full control over ranges and labels. For anything that will be reviewed by a steering group, build manually — you need to be able to explain exactly which cells produced each figure. The AI dashboard builder walkthrough covers where the generated route is genuinely quicker.
5. Select Save in the upper-right area.

Smartsheet documents the full procedure in Create and edit a Smartsheet dashboard, which also lists the plans and permission levels required.

Add and configure the widgets

1. Select Edit Dashboard in the upper-right corner. The right navigation bar exposes three panes: Dashboard theme, Add Widgets and Widget Settings.
2. For a headline number, add the Metric widget, select Add Data, then choose either Grid data or Sheet Summary data. Sheet summary is the more durable choice. With grid data you are binding to cell positions, and anyone inserting a row above your target cell will quietly break the widget.
3. Add the Report widget when stakeholders need the underlying rows, not just a total. You need at least Admin access to the source report to place it, but people shared to the dashboard do not always need access to the underlying sheets to see the report content — which is the main reason to prefer a report widget over linking out to sheets.
4. Add the Shortcut widget for the handful of links people actually chase: the risk log, the change request form, the programme SharePoint folder. Keep it to one shortcut widget rather than scattering links across the canvas.
5. Use the Rich text widget for the status narrative — the two or three sentences explaining why the numbers moved. Use the Title widget to group sections. The narrative is the part executives read; the charts are what they check it against.
6. Add the Web content widget for embedded Tableau views, Smartsheet forms or video. You need access to the source application for it to render.
7. Add the Image widget for a logo or programme mark. Keep it small; it earns no analytical value.
8. For each widget, open Widget Behavior and set what happens on click. Options include taking no action, opening the data source, opening another site, or opening a Smartsheet item. Metric widgets that open the source sheet cut a large amount of “where does this number come from” traffic.
9. Right-click the canvas and select Consolidate Empty Space to remove unused rows between the top and bottom widgets without disturbing the arrangement.
10. Select Save.

Wire a chart to your summary data

1. With Edit Dashboard active, select the + icon on the right rail and choose Chart, or use Edit > Add Widget.
2. In the Data & Chart Type section, select Add Data. You cannot choose a chart type before choosing data.
3. Pick the sheet or report on the left of the form, then select the cell range on the right, and select OK. To change the range later, edit the widget and select Edit Data.
4. Choose the chart type. Smartsheet offers line, smooth line, stepped line, bar, stacked bar, column, stacked column, pie, donut and scatter.
5. Open Columns Included and deselect everything you do not want plotted. This is the single most useful control on the widget and the one people miss.
6. Set the labelling. Toggle Use column names as category labels on to ignore text labels in the cells; toggle Use first column as series labels off to use the top row instead. Use Switch rows/columns if the axes come out transposed.
7. Expand Series to set colours, Legend to set position, and Horizontal Axis or Vertical Axis to set titles and tick mark lines.
8. Open Viewer mode and choose Last widget editor or Their own perspective. This determines whose data view other people see and matters on any dashboard where row-level permissions differ between viewers.
9. Select Done, then Save.

Two constraints will bite during this step. Pie and donut charts do not display zero values, so a status breakdown with an empty category renders differently from what you expect. And the chart widget supports Text/Number, Dropdown list, Auto-Number/System-generated and Symbol columns, skipping cells that contain text, symbols or non-integer values — so a “% Complete” column formatted as text will chart as nothing at all.

Share and publish

1. Select the Share button at the top of the dashboard. If the dashboard sits in a workspace, the dropdown lets you share the whole workspace or just the dashboard.
2. Under Add people by name, email or group, enter recipients, separating multiple addresses with a comma or semicolon.
3. In the Permissions box, select Admin or Viewer. Those are the only two levels dashboards accept — there is no Editor or Commenter tier on a dashboard, as Smartsheet sets out in its guide to sharing a dashboard.
4. Add a Message (optional), set Notify people and Cc myself, then select Share.
5. To publish for people without Smartsheet logins, select File > Publish and set the slider to ON. Under Security Controls, decide whether the link is open to anyone or restricted to users on your Smartsheet plan. Save the dashboard before publishing — the last saved view is the one that publishes.

What each widget is actually good for

Smartsheet’s reference on dashboard widget types lists the full set; the table below adds the limitation that matters for each one in practice.

Dashboard capability by plan

Creating and editing dashboards and widgets requires Owner or Admin permission on the item, on the Pro, Business and Enterprise plans. Publishing is documented as a Business and Enterprise capability, and System Admins can restrict or deactivate it account-wide through Security Controls in the Admin Center.

How dashboards refresh, and the lag people get caught by

This is the source of most “the dashboard is wrong” escalations, and it is entirely predictable once you know the rules.

A published dashboard automatically refreshes once every ten minutes. Smartsheet states plainly that this behaviour cannot be customised or deactivated. If you are running a live steering meeting off a published link and someone updates a sheet mid-session, the screen will not catch up on demand.

Inside Smartsheet, Auto-Refresh under the View menu is a per-viewer setting. Turning it off for yourself leaves it enabled for everyone else. Two people can therefore be looking at the same dashboard and disagreeing about a number because one of them has a stale render.

Web content widgets do not automatically refresh at all. An embedded Tableau view or external chart will sit at whatever it loaded with. If a dashboard mixes native widgets with embedded content, half of it is live and half of it is not, and nothing on screen tells the viewer which is which. Label embedded panels with a rich text note saying when they last refreshed.

Underneath all of this, formula recalculation on the source sheet happens on the sheet’s own schedule. A dashboard cannot be fresher than the sheet feeding it — so if a roll-up sheet is fed nightly by a Data Shuttle import, the dashboard is a daily artefact regardless of how often the widgets repaint.

Sharing, permissions and the published link

Dashboards accept only Admin or Viewer permissions. There is no middle tier, which means anyone who needs to edit a widget gets full control of the dashboard. On programme dashboards with multiple contributing workstreams, this pushes you towards one owner and a change request process rather than shared editing.

Workspace-based sharing behaves differently from direct sharing. People with permission to edit content in the workspace automatically get view access to the dashboard, but editing it still requires Admin. Collaborators shared through a workspace at Editor or Commenter level cannot edit the dashboard.

Seat type also intrudes. Smartsheet’s share window warns that recipients without a Member seat may be limited to view-only access, and you can hover over a name under Manage access to check someone’s seat type before granting Admin.

The published link deserves particular care. Publishing generates a URL anyone can open without logging in, plus an iframe code for embedding. Security Controls let you restrict that link to users on your Smartsheet plan instead of leaving it open, and the restriction applies only to the published link — direct collaborators still reach the item through their own login.

The failure mode nobody plans for: a published dashboard can become unpublished if the person who originally published it loses access to it. If that publisher is removed from the workspace, removed from a group shared to the workspace, or otherwise has their sharing access revoked, the published link stops working. Publish from an account that will outlive the person who set it up, and re-check published links after any reorganisation.

Performance and behaviour at scale

Smartsheet documents unlimited widgets per dashboard above the Pro plan, but unlimited is a licensing statement, not a design recommendation. Every chart, metric and report widget resolves against a live source, so a dashboard with dozens of widgets pointed at large reports takes visibly longer to paint than one with eight widgets fed by pre-calculated summary fields. Pushing aggregation down into the sheet, rather than asking widgets to chart wide raw ranges, is the highest-leverage performance decision available.

A few rendering behaviours to plan around. Dashboard theme colours do not apply to content inside report and web content widgets, so a themed dashboard will have two visually inconsistent panels. You can save up to 39 custom colours per dashboard, and those custom colours are specific to that dashboard rather than shared across your account. On the mobile app, custom colours are replaced with the closest available default colours — so a red/amber/green scheme built on precise hex values will not render as designed on a phone. If executives read status on mobile, test there before you sign the design off, and lean on shape and label rather than colour alone. Chart labels are also hidden automatically at times to keep the chart legible; the fix is a smaller font size or a larger widget.

When a dashboard is the wrong answer

A dashboard is a summary surface. It stops being the right tool in three recognisable situations.

When people need to act on rows, not read totals. If the audience needs to update records they own without seeing everyone else’s, a dashboard cannot do it — the Viewer permission is all-or-nothing on what the widget shows. That is the case Dynamic View is built for, giving granular control over which rows and fields a given person sees or edits. It is an add-on starting at $125 per month on Business and Enterprise, and included in the Advanced Work Management bundle alongside Control Center and Data Shuttle. The Dynamic View setup guide covers how the view definitions are scoped.

When the question requires real analysis. Cohort comparisons, multi-year trend decomposition, joins across systems, statistical work — the chart widget’s single-source constraint and ten fixed chart types are not the right instrument. Push the data to Power BI, Tableau or a warehouse and keep Smartsheet as the system of record. Embedding the resulting Tableau view back into a web content widget is a reasonable pattern, as long as everyone understands it will not refresh with the rest of the page.

When a report would do the job. A report already sorts, filters and (on Business and above) groups and summarises. If the audience is a delivery team rather than an executive, they usually want the report, not a picture of it. Dashboards earn their cost when the audience will not open Smartsheet otherwise.

Scheduling-heavy programmes hit a related boundary: Smartsheet’s dashboard layer summarises schedule data well but does not replace a scheduling engine, which is the trade-off examined in Smartsheet compared with Microsoft Project.

Honest limitations

• No cross-sheet charting. Every chart resolves against one sheet or one report. Multi-source visuals require a report or a formula-built roll-up sheet first.
• Ten-minute published refresh, fixed. Not configurable, not disableable, and unsuitable for anything approaching operational monitoring.
• Two permission levels only. Admin or Viewer. Anyone who edits, edits everything.
• Metric widgets do not track schema changes. Add a summary field to the sheet and you must add it to the widget by hand.
• Mobile rendering diverges. Custom colours are substituted with the nearest defaults in the mobile app.
• Web content widgets are static. They do not participate in dashboard refresh.
• Pro is a genuine ceiling. Ten widgets per dashboard and one sheet per report rules out portfolio reporting.
• Publishing is fragile to staff changes. The link dies if the publisher loses access to the dashboard.
• AI chart availability is unclear. Smartsheet’s pricing comparison lists the AI dashboard builder across all four plans, while the chart widget documentation states that AI tools are available on Trial and Enterprise plans. Confirm against your own account before designing around it.

Common questions

Can a Smartsheet chart pull data from more than one sheet?

No. Smartsheet’s documentation states charts can only be created against data in a single sheet or report. To visualise data spread across sheets, build a report that collects the rows, or use cell links and cross-sheet references to consolidate the values onto one sheet first, then chart that.

How often does a Smartsheet dashboard refresh?

A published dashboard refreshes automatically once every ten minutes, and that interval cannot be customised or turned off. Inside Smartsheet, each viewer controls their own Auto-Refresh under the View menu. Web content widgets are excluded — they do not refresh automatically at all.

Which plan do I need to create dashboards?

Smartsheet documents dashboard creation and editing as available on the Pro, Business and Enterprise plans, for users with Owner or Admin permission on the item. Pro is limited to 10 widgets per dashboard and 1 sheet per report, so multi-project roll-ups realistically require Business or above.

Can external stakeholders view a dashboard without a Smartsheet account?

Yes, through publishing, which generates a URL that works without logging in. Publishing is documented as a Business and Enterprise capability. Use Security Controls to restrict the link to users on your plan, and be aware that System Admins can disable publishing account-wide.

Why is my metric widget showing the wrong number after someone edited the sheet?

Grid data metric widgets bind to specific cells, so inserting or deleting rows above the target shifts what the widget reads. Sheet summary fields avoid this because they are named objects rather than positions. Rebuild grid-bound metrics against sheet summary data where you can.

Sponsored