Clicking a Widget returns a a smartsheet that is filtered?

DEW
DEW ✭✭✭✭✭

Hello.

Here is the issue I am trying to solve:

I have a status report widget that is displayed for a number of users. When they click on it, I would like to link it to the source but only for their section (pre-filter it). Is that possible? I don't want to restrict access (use the advanced viewer radio button).


The scenario: 3 teams (Legal, construction, Resorts) use the same smartsheet and status reports. Legal wants to update their tasks. When they click on the widget, it returns the full unfiltered sheet. They then need to select the filter, etc.

What I want to happen: When they click on the status report, return only those tasks that are for legal (default filter for them only). They can turn it off, but just show their items only. So I would like to do a "user assigned to group" filter (?).


Thanks in advance....

Best Answers

Answers

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

    Hi @DEW

    You could use a filter with Current User, and then it would only show the matching rows to the user that clicked the widget.

    Make sense?

    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.

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    @DEW

    If you filter a sheet you will see that the URL in your browser will add &filterId=765765765765 (a number representing the filter).

    Use this for the link to the sheet and it will be automatically filtered when opened.

  • DEW
    DEW ✭✭✭✭✭
    Answer ✓

    Andrée Starå solution worked perfectly - I wasn't thinking about current user - Thank you so much!!

    Leibel S's solution did not work as the URL does not change based on filtering.

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    @DEW

    It seems as though you made a filter in your sheet to work with Current User applied this filter and saved. You then added a widget with a Smartsheet Item link to this sheet.

    In your case the sheet will open to the filter because you have last saved your sheet this way but another user clicking on it will not automatically have this filter. As well even if they do have it if they remove it for whatever reason the next time they open the sheet they will not have the filter anymore.

    The solution to this is to add a URL link (not Smartsheet item) to your widget and this URL included the &filterId= with the filter number.

    This makes it that no matter who opens it and what they saved previously, the filter will be automatically applied.

    As well, with this process you can have multiple links on your widget and/or other dashboards each with their own filter for the specific use case you require there.