Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Capabilities

Who can use this capability

  • Viewer

Build metric widgets

With the metric widget, you can display content from one or more cells in a sheet.

Who can use this?

Plans:

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions:

  • Viewer

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

After selecting the metric widget type, select Add Data to choose the sheet and cells containing the data you'd like to display.

You have the option of selecting either Grid data or Sheet Summary data as the data source:

  • If you chose Grid data, select the cells you would like to display in the metric widget and select OK.
  • If you selected Sheet Summary data, check the boxes of the sheet summary fields you would like to display and select OK.
  • If you want to display the data in a grid format, you need to first create a report and use the Report widget type.
  • If you want to display new fields as they’re added to or deleted from the source sheet, then you need to manually add or remove them from the metric widget as well.

Once you've chosen the data to display, use the following steps to make the widget look the way you want.

To do this
 
Follow these steps
Change the alignment of the data in the widget

In the widget properties panel, select either Stacked or Side-by-Side.

Change font formattingClick the cursor on the item you want to change, then use the popup formatting menu to change your text. 
Add a title to the widgetUnder the Title section of the configurator, toggle Show title on. 
Adjust the formatting for each field in the widgetTo do this, click the field directly within the widget and then choose from the available formatting options on the toolbar.
Enable the formatting from the underlying sheet to show in a field

Click on the field and then select Use Cell Formatting:

Edit the interaction of the widget (interaction is what happens when you click the widget)

While editing the widget, navigate to Widget Behavior in the configurator and choose an option from the When someone clicks this widget list of options:

  • Do nothing (no action)
  • Open the source sheet
  • Go to a URL
  • Open a Smartsheet item