Current User Report on Dashboard - NOT SHARED

Today if you are using a Current User Report on a Dashboard you have to be shared to the source sheet.

If I don't want people to see the data, there is no easy solution. Please allow the current user report to work by filtering in for view on the dashboard, not source data.

Dynamic View doesn't have all the features of a Report so this does not fix the issue. Also on the mobile app, it displays as a link.

Sign in to vote!

Find more posts tagged with

Mobile

Reports

Dashboards

Idea Submitted

Dynamic View

Comments

Andrée Starå

Hi @Joe Goetschel

I hope you're well and safe!

Here's a possible workaround or workarounds

Premium App, WorkApps.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Joe Goetschel

Nope unironically I originally used Dynamic View on a workapp but it's lacking features. I rather have it on a Dashboard in workapp BUT Dynamic View doesn't have the grouping, and auto counting/Sum like Reports do. Also on a dashboard on mobile Dynamic view only shows up as a link. I can't win.

With all options, I can get 90% there but not 100%

bsikes

Running into this now. Would love to be able to have the option from a report to bypass the need for source sheet permissions.

I'm trying to build a proof-of-concept dashboard that shows where the current user is within a process, but they can't have permission to the source sheet with commingled data. Functionally works, but only with the source sheet permissions.... Bummer!

jessica.smith

I want to be able to create a chart on a dashboard that shows a user data that is specific to them without having to share the underlying report and sheets.

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…