Only Display Rows Selected by the User on a Dashboard
Hi,
Can the following be done within Smartsheet?
I have an inventory sheet containing a list of projects. I need to display this sheet on a dashboard (via a report?).
Each user viewing the dashboard only cares about certain projects. For example: User A only cares about projects 4, 9, 15, and 23. User B only wants to see projects 1, 4, 23, and 46. Etc.
Is it somehow possible to display only projects on the dashboard which each specific user cares about? So it's almost like a subscription model, where the user chooses which projects to see, and then those projects are displayed on a dashboard.
Is this even possible?
Thank you,
Ron
Best Answer
-
Hi @Ron B.,
ameyaa is on the right track with getting a "Current User" view of projects on a Dashboard via a Report but users wouldn't be able to switch between viewing one of their projects or only a few of their projects. I think what would be beneficial would be to have a Dashboard-specific filter for people to use to only see certain widgets based on specified criteria (e.g., "If project is one of... then show that report in the dashboard and hide the others). If this is more if what you're looking for, I highly recommend Submitting a Product Enhancement Request to see about having this considered as a possibility for future development.
For more information on Reports and working with reports in Dashboards, visit the following Help articles from the Learning Center:
I hope this helps!
Thanks,
Ben
Answers
-
I can think of one way, not tried it yet though. Assuming the user A is also the creator or assigned to projects 4,9,15 and 23. Then you can create a report with setting the 'who' value to created by/assign to 'current user' and then pulling that report into dashboard.
-
Thank you for the idea, Ameyaa.
-
Hi @Ron B.,
ameyaa is on the right track with getting a "Current User" view of projects on a Dashboard via a Report but users wouldn't be able to switch between viewing one of their projects or only a few of their projects. I think what would be beneficial would be to have a Dashboard-specific filter for people to use to only see certain widgets based on specified criteria (e.g., "If project is one of... then show that report in the dashboard and hide the others). If this is more if what you're looking for, I highly recommend Submitting a Product Enhancement Request to see about having this considered as a possibility for future development.
For more information on Reports and working with reports in Dashboards, visit the following Help articles from the Learning Center:
I hope this helps!
Thanks,
Ben
-
Thank you Ben G.
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 in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
