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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's lin…
- Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form conne…
- I setup a new Smartsheet and am connecting it to Jira Cloud. All fields are syncing properly except the Team field. I have the column set up as text number but have also tried it as a Drop Down list. …
