Current User - Dashboard/Report
I have a report that is based off of the "Current User" as I am not shared to the underlying sheet. This report is housed on a Dashboard. The Widget is pointing to the "Dashboard Viewer", HOWEVER when I am looking at the Dashboard - there is no information showing, which is incorrect.
Best Answer
-
If you have an Enterprise or Premier plan the new WorkApps solution recently released in preview would maybe be perfect for this use-case.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Answers
-
Hi Jenna,
For any report, you need to be shared to the underlying Sheet(s) referenced in that report to see the data. The Current User feature is intended to adapt to the viewer of the report and show them only line items where their name is listed in a specified contact column.
If you/your organization wants to share users to a sub-set of Sheet level information without Sharing the full Sheet, the options are:
- Hide the columns in the Sheet that should not be seen, Share the Sheet to users as Editors (Admins can unhide columns). This is not fully-full proof, it will also allow users to use Reports.
- Publish the Sheet with appropriate editing settings, and give users the link tot he published Sheet with appropriate data hidden.
- Get Dynamic View Premium Add-On, this is the best option but comes at an additional annual cost.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thank you for the response, however, I feel like this is an extremely big shortfall for Smartsheet.
-
If you have an Enterprise or Premier plan the new WorkApps solution recently released in preview would maybe be perfect for this use-case.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Thanks @Andrée Starå, I think WorkApps is a great start for sure. However, I stalled on using it because click-through reports off of metrics don't seem to work.
-
What do you mean? What didn't 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.
-
I got it going - sorry. User error :)
-
Excellent!
Glad you got it working!
✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives