Highlight key numbers directly on your dashboard by pulling data from one or more cells in a sheet.
USM Content
Metric widgets are ideal for surfacing at-a-glance metrics, like budget totals, task counts, or status summaries, so stakeholders can monitor what matters most without opening the underlying sheet.
Add a metric widget
- Open the dashboard you want to edit.
- Select Edit Dashboard > +Add Widget. The Add Widget panel appears.
Select Metric. The right panel opens.
Brandfolder Image
- Select Add Data.
- Choose the sheet and cells containing the data you want to display.
- Select 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.
Keep in mind:
- If you want to display the data in a grid format, 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, make it look the way you want:
Configure | Steps |
|---|---|
Layout | Select Stacked or Side-by-side, this changes the alignment of the data and its name. Select the Position and Align content. |
Title | Toggle on or off the Show title option. Here you can toggle on and off, edit, and format the widget title. You can also edit the formatting for a specific field in the widget. Select the field directly within the widget, and then choose from the available formatting options on the editing panel. |
Widget behaviour | Select what happens when you select the widget:
|