Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

Licensed Owners and Admins can create or edit a dashboard. 

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

Create and edit a Smartsheet dashboard

Dashboards provide tools that put the power of visualization in the user's hands. Dashboards are the visual layer of work and allow you to summarize and share real-time data, project status, and key performance indicators with stakeholders.

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions

Licensed Owners and Admins can create or edit a dashboard. 

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

Get started on creating and making changes to your dashboard.

Create a new dashboard

  1. In the Home screen, select Create solution.
  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 Owner or Admin of a dashboard, you can change the dashboard's 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 Settings: Select a background color or font for the entire dashboard.
    • 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 Widget: 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. Or, you can 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 > Settings
  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. You can also set your widget to Transparent, and it inherits the color from the underlying dashboard. 
  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.
  2. In the View menu, select Auto-Refresh.
  3. 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.

Was this article helpful?
YesNo