Report Widget using Current User Filter returning "Widget Results are empty for you"

Options

I have created an employee leave dashboard (employees have been shared to this with "Viewer" rights. One of the report widgets is a Leave Balance report. Which is also shared to the users with "Viewer" rights. The Leave Balance report ha a filter in place to only show the Current User.

It all works as expected when I am using it (Admin/Editor) I only see my leave balance, but when having a employee test (with Viewer) access to the dashboard and the report, the widget report displays the following "Widget results are empty for you". But the user does have leave balances.

Any ideas would be appreciated.

Best Answer

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 03/16/21 Answer ✓
    Options

    Hi @Peter Goodwin

    Hope you are fine, please try the following. open report Widget in the dashboard and select advance then select as by the following screenshot Dashboard Viewer, please read the following article it will help you to understand Control Widget Content When Source Is From a Report:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Peter Goodwin
    Options

    Hi Bassam, thanks for the reply. Unfortunately it means I cannot provide the solution I wanted to as the person with viewer access cannot take advantage of the "Current User" option when viewing the report. So on the employee dashboard I cant use this method to show their leave balance. Cannot think of another way around this. The majority of my users are viewers only of the dashboard, and do not want to give them view access to the underlying sheet, as that contains all employees info, to which they should not have access. Also the bulk of my users are not licenced. If you can think of another way to surface this info on a dashboard I would be most appreciative.


    many thanks, Pete

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Peter Goodwin 

    Please send a copy of your sheet to my Email (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    My Email: Bassam.k@mobilproject.it

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Peter Goodwin

    I hope you're well and safe!

    To add to Bassam's excellent advice/answer.

    What license do you have in Smartsheet? If you have Enterprise or higher, you could use a WorkApp instead because they wouldn't need to be shared to the underlying sheet.

    Another option.

    I recently developed a (what I call) Dynamic View Light. It's quite advanced, but in short, it's using cross-sheet formulas and INDEX/MATCH and a specific structure and method, so it's only possible to show data that should be available.

    Would any of those options 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.