filtered views

Hi all,

I am trying to embed hyperlinks into a sheet that will pull up the filtered view of the sheet when clicked. Is this possible? or do I need to make and link reports, rather than a sheet filter. I'd rather not do the extra work of making reports, so I'm hoping theres a better way

When I click on the link I want it to give me the filtered view of the sheet in what ever view I choose.

Is this possible with the regular subscription?

Thanks in advance

Find more posts tagged with

functionality

Accepted answers

All comments

Andrée Starå

Hi @Sarah_lee123

I hope you're well and safe!

Yes, it's possible, but it will open the Filtered view in another tab.

You'd need to add the filter, change the view, and then you can copy the URL and paste it in a cell or use the Hyperlink feature to name the URL something else.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah_lee123

Thanks @Andrée Starå I tried that at first and it just defaults to which ever filter is active on the page at the time. I have multiple filtered links on one project management page. When I go through and click each link to check on it, they all have the same filter as each other. I tried to copy and paste the link directly from the sheet as well as publish the filtered view in to the hyperlink.

I'm not getting the functionality I expected. I'll play around with it a little bit more and see where I can get.

Thanks for your help

~Sarah

Andrée Starå

@Sarah_lee123

Happy to help!

Have you checked if there's a Default Filter adding to the Sharing settings?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.