Dynamic View: Current User for Dashboard
I need to have current user view works on a dashboard report widget. May I know if it can be done by Dynamic View? I need to restrict user's view on the dashboard depending on who the user is and not sure if Dynamic View is a solution or not. Thank you!
Comments
-
Hi Peggy,
Unfortunately, it's not possible with Dynamic View at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
How would you like to restrict the view on the Dashboard?
Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thanks for your reply! We created a master sheet to collect issues and a report sourced from a sheet summarize how many issues are logged by country. This issue log summary report is added to dashboard as report widget. We need each user only see the summary for their country(s) and not the others. I have attached a sample of the said report widget. Thank you and have a nice day!
-
Happy to help!
Unfortunately, it's not possible at the moment to have a report change what it shows in a dashboard dynamically for the current user, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
As a possible workaround, you might use a link to the report instead. When it's opened, it will use the current user criteria only to show the relevant information. (the users have to be shared to the underlining sheet)
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thanks for your advice but I am afraid a link to the report is not the solution we are looking for.
What if I use Dynamic View in the summary sheet to customize the view for different users and then add it as a web content widget in dashboard? Will that make the dashboard at current user view?
-
Happy to help!
Yes, Dynamic View would work perfectly. (why didn't I think of that).
It will only be the Dynamic View that would filter on the current user.
Let me know if you have questions or if I can help with anything else!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Here's why I didn't think of it. It was just released!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thanks a lot for sharing! It looks like Dynamic View is the solution we are looking for. May I know if only administrator/ sheet owner will need the license of Dynamic View or each end user accessing the sheet/ dashboard will also need license of Dynamic View?
For example if I have Dynamic View license and create a sheet with customized views to filter current user, then I add it as a web content widget in a dashboard. When any editor/ viewer accessing the dashboard without Dynamic View license, will they be able to see the dashboard in a current user view?
Hope I made my question clear as we need to know how many licenses will be needed for this solution. Thank you!
-
Happy to help!
It's not priced by a user but by how many Dynamic Views you need.
The current user will only work for the Dynamic View in the web content widget, and everything else would be the same and not dynamic.
I'd be happy to have a chat to see what solution would work best and if there might be any workaround that could work. Please email me at andree@workbold.com and well take it from there.
Hope that helps!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives