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!

Find more posts tagged with

Finance

Comments

Andrée Starå

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

Peggy Huang

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!

Andrée Starå

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?

Peggy Huang

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?

Andrée Starå

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!

Andrée Starå

Here's why I didn't think of it. It was just released!

https://www.smartsheet.com/content-center/product-news/product-releases/interact-your-work-directly-dynamic-view-dashboards

Peggy Huang

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!

Andrée Starå

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…