Filter for Current User - View on Dashboard not working as planned
Hello Smartsheet people,
I have a report that is pulling in all open tickets from a single source sheet, and I want the report displayed on a dashboard. I want this specific report to only show the tickets assigned to the current viewer of the dashboard.
The 'has current user' filter is on, and the column type is a contact column. Yet, my boss can only see my tickets, and nothing that she has assigned to her.
What am I missing? Or is this a feature of Dynamic view
-Matt
Best Answer
-
Check the Report widget Advance Options. If Widget editor is selected, everyone who views the dashboard will see your tasks since you created the Dashboard. If you want the viewer to see their tasks, you have to change the setting to "Dashboard viewer".
Answers
-
Does your boss have access to the source sheet?
A user has to have access to the source sheet of a report to see the content in the report.
Richard E. Lucas
-
Hi Richard,
Yes, she has access. She has Admin privileges in the workspace the sheet is in.
-
Check the Report widget Advance Options. If Widget editor is selected, everyone who views the dashboard will see your tasks since you created the Dashboard. If you want the viewer to see their tasks, you have to change the setting to "Dashboard viewer".
-
Thank you Joi!
That worked.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives