Dashboards

APPLIES TO

  • Smartsheet
  • Pro
  • Business
  • Enterprise

RELATED CAPABILITIES

Who can use this capability?

  • Owners 
  • Admins

Dashboards are a communication tool that provide real-time visibility into critical data and centralize all the information that your team needs in a single place. 

Dashboards are made up of easy-to-configure widgets, the building blocks for dashboards, that display the live data from your sheets and reports. Dashboards can be shared with anyone, including teammates, executives, and even external customers, and are easily viewed on the desktop or the Smartsheet mobile app. 

Sharing a live dashboard with your different stakeholders ensures you’re able to get the right information to the right people, at the right time, to make informed decisions. They can also serve as a team portal to centralize all of the information and resources about your program, process, or team in one place. 
 

Follow the step-by-step instructions to create a dashboard.

Create and edit a Smartsheet dashboard

APPLIES TO

  • Smartsheet
  • Pro
  • Business
  • Enterprise

RELATED CAPABILITIES

Who can use this capability?

  • Owners 
  • Admins

You must have sharing permissions to the source sheet or report to add data to chart, metric, and report widgets. 

Get started on creating and making changes to your dashboard.

Create a new dashboard

  1. On the Home screen, select Create solution (either from the blue button at the top of the screen or from the + icon on the left rail).
  2. Select Dashboard.
  3. Type a name for your dashboard, and then select OK
  4. Select Edit Dashboard Edit Dashboard iconto edit and add information to your new dashboard.
  5. Add the appropriate dashboard widgets
  6. In the upper-right area of the dashboard, select Save.

Edit a dashboard

If you're the dashboard's Owner or Admin, you can change its background color and add or edit a widget. You can also access extra editing features from the shortcut menu.

To edit your dashboard

  1. In the upper-right area of the screen, select Edit DashboardEdit Dashboard icon.
  2. On the right Navigation Bar, select any of these panes:
    • Dashboard theme: Select a color theme for the entire dashboard and apply it to all your widgets. You also can customize the canvas color.

Theme colors don’t apply to content within report and web content widgets. 

  • Add Widgets: Add the widgets you want to appear on your dashboard. 
  • Widget Settings: Edit a widget on your dashboard.
  1. Once you're done with your edits, select Save in the upper-right area of the screen.

Need more information about adding and editing dashboard widgets? Read the Add and Edit Widgets on Your Dashboard article.

Use the shortcut menu to edit your dashboard

Right-click anywhere on the grid, and then select any of these actions:

  • Paste Here: Paste a widget you copied.
  • Dashboard Settings: Change the background color or font.
  • Add Widget: Add widgets to your dashboard. 
  • Consolidate Empty Space: Delete unused rows between top and bottom widgets to consolidate a dashboard's vertical space. This presents the most compact version of the current dashboard without affecting how the widgets are arranged.

Image widgets on your dashboard

You can drag images from a folder on your computer directly to the dashboard; when you drop the image, Smartsheet creates an image widget for you. You can also create the widget and then drag the image onto the widget. 

Hover over the image widget to change an image via the file selector. 

Layout

  • Fill: Default. The image keeps its aspect ratio and fills the widget container. The image will be clipped to fit.
  • Fit: The image keeps its aspect ratio but is resized to fit within the widget container.
  • Actual:  The image displays at actual size

Margins 

  • No margin: Default.
  • With margin: 20px

Apply custom colors

When selecting colors for fonts, charts, titles, and more, you can choose from standard presets or add a custom color using a HEX code, an RGB code, or a color gradient. 

To create a custom color

  1. In the top right corner of the dashboard, select Edit > Dashboard theme
  2. Under Dashboard color or Widget color, select Change, and then select the plus icon. 
  3. Pick a color or enter the hexadecimal color value. 
  4. Select Add.

What you should know about custom colors

  • You can save up to 20 custom colors on a dashboard.
  • Custom colors are unique to the dashboard; the setting doesn’t apply to other dashboards. You can quickly select the same custom color on different widgets if they’re on the same dashboard.
  • Start a new dashboard from your current one to keep the custom colors and other items in it. To create a copy of the dashboard, select File > Save as New
  • When viewing a dashboard in the mobile app, custom colors are replaced by the closest available default colors.

Automatic refresh on dashboards

A published dashboard automatically refreshes every 10 minutes. You can’t customize or turn off this behavior.

You can only change the Auto-Refresh feature for your view of the dashboard. For example, if you turn off Auto-Refresh, it'll remain enabled for other collaborators who are viewing the dashboard.

To change the frequency or to turn off the Auto-Refresh feature

  1. In the menu bar, select View >Auto-Refresh.
  2. Select the change you'd like to apply:
    • Select your frequency. 
    • To turn off the Auto-Refresh feature, select Off.

Web Content Widgets don't automatically refresh on dashboards.