Options
Jenna Bailey ✭✭✭✭✭
10/08/20 in Smartsheet Basics
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.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
10/20/20 Answer ✓
Options
Hi @Jenna Bailey
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.
5 · Share on FacebookShare on Twitter
Answers
SoS | Dan Palenchar ✭✭✭✭✭✭
10/08/20 edited 10/08/20
Options
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.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.
- 🆘 Smartsheet Consulting Inquiries:schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos:schoolofsheets.com/youtube
PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!
0 · Share on FacebookShare on Twitter
Jenna Bailey ✭✭✭✭✭
10/08/20
Options
Thank you for the response, however, I feel like this is an extremely big shortfall for Smartsheet.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
10/20/20 Answer ✓
Options
Hi @Jenna Bailey
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.
5 · Share on FacebookShare on Twitter
Jenna Bailey ✭✭✭✭✭
10/20/20
Options
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.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
10/24/20
Options
@Jenna Bailey
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.
0 · Share on FacebookShare on Twitter
Jenna Bailey ✭✭✭✭✭
10/27/20
Options
I got it going - sorry. User error :)
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
10/30/20
Options
@Jenna Bailey
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.
0 · Share on FacebookShare on Twitter
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.2K Get Help
- 88 Global Discussions
- 91 Industry Talk
- 398 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 42 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 250 Events
- 13 Webinars
- 7.3K Forum Archives
Watch video