Create a Link to A Filtered Sheet

Bladerunner

Does anyone know of a way to link to a filtered sheet? I want to create a number of links on a dashboard which when clicked on will show the same smart sheet but with a different filter applied.

e.g. I could have a link that says "Red items" and another that says "Blue Items"  the interaction on the link would be to open the another smartsheet with the saved filter "Red Items" or "Blue Items" applied automatically...

Andrée Starå

Hi,

Yes, if you select the filter that you want to be applied and then copy the URL and use that as the link on the dashboard, it will open with the filterer view.

Another way could be to create different reports instead. What would work best depends on your specific workflow and need.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Bladerunner

Hi Andree, I think that will do it thank you.

It would be nice if it was listed as a smartsheet item when linking from a dashboard.

 

Kind regards.. Ben

Andrée Starå

Excellent!

Happy to help!

To be able to select the filter as part of the item would be a significant enhancement! Great idea!

Please submit an Enhancement Request when you have a moment.

Best,

Andrée

Paul Simon

This is a no-brainer request. Surprised after all these years I still can't find this functionality.

If we are using a Smartsheet to track a project or datasheet it should be feasible for me to share a link with exactly the view I want to share on the fly. I should need to create a report for every time I want to discuss a section of the spreadsheet with another colleague. If I am using a filter to limit my results, and especially if it is a saved filter I would expect to have a unique URL for those results which I can rapidly share with teams I am collaborating with.

Please tell me this has been implemented but it's so intuitive that I am overlooking it 😃

Thanks

Paul

Genevieve P.

Hi @Paul Simon

If the filter is a Shared filter, then there will be a unique Filter ID at the end of the URL. Providing that specific URL with the filter ID will enable all users to open the sheet with the filter automatically applied. 🙂

You can also set a default filter on the sheet in the Share window.

Cheers,

Genevieve

Paul Simon

Hi @Genevieve P.

Thanks for your response, that's already a great start.

In our case we are using Smartsheet's Project Portfolio and Project Program Planning functionality (i.e. sheet with Gannt)

and

Issue / risk logs and test script trackers where we often want people to have a look at a couple of sections, 2-3 lines of items in these.

We don't like sharing screenshots as this limits adoption of Smartsheet. People wait for the emails don't look and actively update Smartsheet.

On the other hand we don't want to have to create a filter for every item we want to share a section of a project plan, test execution tracker or issue logger. For some standard items that works and it is fine but for others it is not. Excel obviously lets you do that easily. We would expect this to be feasible in Smartsheet especially if Smartsheet is to be scaled.

Cheers

Paul