Access for Non-plan users
I have having an issue with users not on my same company's plan accessing information from a report via a dashboard.
I have a large sheet of projects. That sheet feeds into a report that is "filtered by current user" based on one of the columns that lists specific people related to that project. That report is embedded as a widget in a dashboard.
The dashboard Publish information is set to "Available to anyone with the link".
The report Publish information is set to "Available to anyone with the link".
Everything seems to function as expected for users within my own company (on the dashboard, they see the report filtered to only their own projects).
For users not in my company, when looking at the report itself, they see the report filtered as the last company person that viewed the report. It's not filtering by the current user, it's filtering by the last person that viewed it.
When users not in my company look at the Dashboard, the report widget tells them that the report is not available, and they don't see any portion of the report at all (not even the incorrectly filtered one that they can see if they look at the report directly). The dashboard report widget view is set to "Their own perspective".
I feel like I'm missing a settings somewhere that allows non-plan users to filter by their own login, instead of seeing the last plan user's filter… But I don't see an option for that anywhere on the report.
Answers
-
"Current user" filter doesn't play very nicely for published reports when you go outside your company. It's logical why it wouldn't work… when you take it to the point of absurdity: "ANYONE can view this! Hooray! Y'all have TOTAL access!" is incompatible with "BUT HANG ON NOW; HOLD UP HERE - WHO ARE YOU?!?!" (which is essentially what Current User filtering is).
The only thing I've found to get around this inconsistency (and I won't lie; it gives me a serious case of the huhhh's because of how unscalable it is) is to create an individual report filtering to One Person - not as current user, but as "John Doe" as used in your project - and then publish that report specifically for ol' John here. That might work for one or two people, but it gets unmanageable really quickly as it grows in scope.
Similarly, a Dashboard is technically a window through which you can view other Smartsheet assets. If you use "Link to a Smartsheet item" on your dashboard (e.g. Report widget), the sharing of that report (and therefore the underlying sheet/s) governs how it's viewable. To get around this, you'd need to use a Web Content widget and post the publish URL. Alternatively, you can use Dynamic View (if you have it) as a way to surface data.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
