Smartsheet dashboards are one of the platform’s most powerful — and most underused — features. A well-built Smartsheet dashboard transforms raw project data into real-time visual command centers that executives, project managers, and clients can understand at a glance. This complete 2026 guide covers everything: how dashboards work, every widget type, how to build charts from sheet data, best practices for layout design, and how to use Smartsheet’s new AI-powered chart generation to build insights in seconds.
What Are Smartsheet Dashboards?
Smartsheet dashboards (formerly called “Sights”) are dynamic, real-time visual displays built from your Smartsheet data. Unlike static reports, dashboards automatically update whenever the underlying sheets or reports change — meaning stakeholders always see current data without anyone needing to manually refresh or redistribute a file.
Dashboards are composed of widgets — configurable display blocks that can show metrics, charts, reports, images, rich text, URLs, and more. You arrange widgets in a drag-and-drop canvas, connect them to live sheet data, and share the result with anyone — including clients and executives who don’t have Smartsheet accounts (via public URL).
In 2026, Smartsheet has enhanced dashboards with AI-powered chart generation — you can describe what you want to see in natural language and the AI builds the appropriate chart widget from your data automatically.
Who Can Create Smartsheet Dashboards?
To create or edit a Smartsheet dashboard, you must be either the Owner or an Admin on that dashboard. You must also have at minimum Viewer access to any sheets or reports you connect as data sources. Dashboard Viewers (stakeholders, clients) only need the dashboard link — they don’t need a Smartsheet account if you share via public URL.
The 7 Smartsheet Dashboard Widget Types
1. Metric Widget
Shows a single key number pulled from a specific cell in a sheet — ideal for KPIs like total project budget, items overdue, or percentage complete. You can add conditional formatting to turn the number red/yellow/green based on thresholds.
Best use: Executive dashboards showing 3–5 critical metrics at the top of the page (Budget Used: $X, Tasks Overdue: X, On-Track %: X%)
2. Chart Widget
Displays data from a sheet or report as a bar, column, line, pie, or donut chart. You select the data range, choose the chart type, and Smartsheet renders it as a live updating visual. In 2026, the AI chart builder lets you describe the chart you want in plain English (“Show me a bar chart of budget by department from the Project Budget sheet”) and the AI selects the right data range and chart type automatically.
Best use: Status breakdowns (% tasks by status), budget vs. actual comparisons, timeline progress bars
3. Report Widget
Embeds a live Smartsheet Report directly in the dashboard — stakeholders can see the sortable, filterable tabular data without needing access to the underlying sheets. Report widgets support cross-sheet reports, giving you a portfolio view of all projects in a single table.
Best use: Project portfolio tables, resource allocation views, issue tracking logs
4. Shortcut Widget
A clickable button or link widget that directs users to any URL — a specific Smartsheet sheet, a Google Drive folder, a Confluence page, or any web address. Multiple shortcuts can be grouped together for a navigation panel.
Best use: “Quick links” panels for frequently accessed sheets, external docs, or tools
5. Image Widget
Displays a static or linked image on the dashboard — typically used for company logos, project maps, org charts, or milestone graphics.
6. Rich Text Widget
A formatted text block for narrative context, instructions, section headers, or explanatory notes. Supports bold, italic, headers, and bullet formatting. Use it to add section titles between widget groups or to explain what a metric means.
7. Web Content Widget
Embeds any public web page or URL inside the dashboard using an iframe. Common uses: embedding a Power BI report, a Looker dashboard, a Google Map of project sites, or a live Tableau visualization.
Step-by-Step: How to Build a Smartsheet Dashboard
Step 1: Prepare Your Data Sources
Before building the dashboard, ensure your sheets and reports are structured for clean visualization:
- Create a Sheet Summary Report if you need portfolio-level metrics across multiple projects
- Ensure your sheets have consistent column structures and column types (Date, Number, Text, Checkbox)
- Build the Smartsheet Reports you plan to embed before you start the dashboard
- Identify the specific cells for Metric widgets (e.g., a COUNTIF formula cell that counts overdue tasks)
Step 2: Create the Dashboard
- In Smartsheet, click the + icon in the left sidebar → select Dashboard/Portal
- Name your dashboard (e.g., “Q3 Project Portfolio Dashboard”)
- The dashboard opens in edit mode with a blank canvas
Step 3: Add and Configure Widgets
- Click Add Widget in the top toolbar
- Select your widget type (Metric, Chart, Report, etc.)
- Connect the widget to your data source: choose the sheet or report, then select the specific column/cell/range
- Configure display options: title, font size, colors, and conditional formatting
- Resize and reposition by dragging widget corners and borders
- Repeat for each widget you want to add
Step 4: Build a Chart Widget (Detailed)
- Click Add Widget → Chart
- Select the sheet or report containing your data
- Click Select Data Range — choose the columns and rows you want to chart
- Smartsheet suggests a chart type based on your data. Override if needed: Bar, Column, Line, Pie, Donut, or Area
- Use the AI chart builder (2026 feature): click “Ask AI” and describe your chart — e.g., “Bar chart showing tasks by assignee, colored by status” — and the AI selects the correct range and type
- Set the chart title and click Done
✅ Pro Tip: Use Reports as Chart Data Sources
Instead of charting raw sheet data, build a Smartsheet Report first to filter and group the data exactly how you want it, then connect your chart widget to the report. This gives you much more control over what data appears in the chart and keeps charts clean even as your underlying sheets grow.
Dashboard Layout Best Practices for 2026
The “F-Pattern” Dashboard Layout
Users scan dashboards in an F-pattern — left to right across the top, then down the left side. Design accordingly:
- Top row: Your 3–5 most critical metric widgets (the headline numbers)
- Second row: Your most important charts (status breakdown, budget vs. actual)
- Left column: Portfolio report table or navigation shortcuts
- Right area: Supporting charts, secondary metrics, or web content embeds
- Bottom: Rich text explanations, last-updated notes, or archive links
Color Strategy for Executive Dashboards
- Use Smartsheet’s conditional formatting on Metric widgets: green = on track, yellow = at risk, red = critical
- Limit your chart color palette to 3–4 colors maximum for readability
- Use your organization’s brand colors via the Image widget for logos and banners
- Dark background dashboards are harder to print — use a light background for dashboards shared via PDF export
Sharing Smartsheet Dashboards
Portfolio Dashboard: A Real-World Example
Here’s how a PMO team might set up a portfolio dashboard to track 8 simultaneous projects:
- Row 1 (Metrics): Total Projects (8), On Track (5), At Risk (2), Critical (1) — using Metric widgets with red/yellow/green conditional formatting
- Row 2 (Charts): Donut chart of projects by status, Bar chart of budget used vs. allocated by project
- Row 3 (Report): Cross-sheet Sheet Summary Report showing all 8 projects with % complete, owner, and health status
- Row 4 (Shortcuts): Quick links to each of the 8 individual project sheets
- Rich Text: “Last updated: [manual date]” and escalation contact info
Smartsheet Dashboard vs Google Data Studio vs Power BI
Bottom line on tooling: For teams whose primary work lives in Smartsheet, native dashboards are the fastest path to visibility. For advanced cross-system BI, Power BI or Looker Studio are worth the additional complexity — and Smartsheet’s Web Content widget lets you embed them directly in your dashboard anyway.
Frequently Asked Questions: Smartsheet Dashboards 2026
How many widgets can I add to a Smartsheet dashboard?
There’s no strict widget limit per dashboard, but performance degrades noticeably above 30–40 widgets — especially if many are connected to large reports or sheets. For complex scenarios, split your dashboard into multiple focused dashboards and link them using Shortcut widgets.
Can I schedule automatic dashboard email reports?
Smartsheet doesn’t natively email dashboard snapshots on a schedule. However, you can schedule Report emails (via Smartsheet’s automated report email feature) which can serve as a substitute. For full dashboard email delivery, tools like Smartsheet’s Premium Add-ons or third-party integrations are required.
Do Smartsheet dashboards update in real time?
Yes — dashboards refresh automatically whenever the underlying sheets or reports are updated. The refresh happens when you load or reload the dashboard page. There’s no manual “refresh” step required for viewers.
Can I use Smartsheet dashboards without a Smartsheet account?
Yes — when shared via public URL (read-only), anyone can view a Smartsheet dashboard without a Smartsheet account or login. This makes dashboards ideal for sharing with clients, executives, or board members who aren’t Smartsheet users.
What Smartsheet plan do I need for dashboards?
Dashboards are available on Smartsheet Pro and above. The Free/Trial plan does not include dashboard creation. On Pro, you can create up to 3 dashboards per workspace. Business and Enterprise plans unlock unlimited dashboards and advanced sharing options.
📚 Related Reading on WorkManagement Hub
🔗 Official Resources & Further Reading
🎯 Expert Bottom Line
Smartsheet dashboards are the bridge between raw project data and executive visibility. A well-structured dashboard with 3–5 metric widgets, 2 charts, and an embedded portfolio report can replace a dozen status emails and monthly deck updates — delivering real-time clarity to stakeholders who need it most. In 2026, the AI chart builder removes the last barrier to adoption, letting anyone build meaningful visualizations without knowing which data range to select. If you’re using Smartsheet without dashboards, you’re doing the hard work twice.
