Clicking a Widget returns a a smartsheet that is filtered?

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....

Find more posts tagged with

Accepted answers

DEW

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.

Andrée Starå

@DEW

Excellent!

You're more than welcome!

✅Remember! 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!

All comments

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!

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

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.

Andrée Starå

@DEW

Excellent!

You're more than welcome!

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.