Pivot Tables on Dashboards

Joan Doyle

Has anyone found a way to display a Smartsheet pivot table on a dashboard? I have created a pivot table that summarizes my data, which include multiple lookups and would like it to appear on the dashboard.

MCorbin

The Pivot table saves as a sheet, so there are a couple of ways that you could display it on a dashboard:

1) "Publish" the sheet and then use the publish URL in a Web Content Widget on the DB

2) Create a report that pulls the rows from your Pivot Table, and use that in a Report Widget on your DB.

Joan Doyle

Thanks!

MCorbin

The Pivot table saves as a sheet, so there are a couple of ways that you could display it on a dashboard:

1) "Publish" the sheet and then use the publish URL in a Web Content Widget on the DB

2) Create a report that pulls the rows from your Pivot Table, and use that in a Report Widget on your DB.

MCorbin

OH! And a 3rd way.... Use a Chart Widget to display the data from your pivot in a graphical format.

Joan Doyle

Thanks!

Joan Doyle

Thanks I ended up using a report and it works great