Pivot Tables on Dashboards
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.
Best Answers
-
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.
-
Thanks!
Answers
-
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.
-
OH! And a 3rd way.... Use a Chart Widget to display the data from your pivot in a graphical format.
-
Thanks!
-
Thanks I ended up using a report and it works great