I have a report pulling data from multiple sheets on a dashboard: Filter Report?
Answers
-
Hi Elaine,
There currently isn't a way to adjust the Report Criteria from a Report widget on a Dashboard - you would need to navigate to the Report itself then open up the Report builder to adjust what rows it's pulling in.
If you have set views you want to bring in, you could create & save multiple types of Reports in one Workspace. Then you could have quick-links via the Shortcut Widget to each of the types of views, based on what the user wants to see. Alternatively, you could publish a view of each individual Sheet and embed it using the Web Content Widget which would allow you to use a Filter on that one sheet in the Dashboard.
Let me know if either of these ideas will work for you!
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!