End users able to create their own filters on sheets in WorkApps?

Julia C Peterson · 05/19/22

I was just trying workapps for the first time and it appears to me that unless you are the admin/owner of the workapp, you can't create a new filter while viewing a sheet in workapps. This makes workapps useless for so many scenarios.

Is this the case? It blows my mind that they would design it this way. I feel like no matter the project/function/industry, no matter what people need to be able to filter any spreadsheet they are looking at. If they can't they will just use excel instead

I know you can create shared filters as an admin but it would be time consuming and it would still never allow someone to look up a specific row on their own. grrr....😫

Genevieve P. · 05/20/22

Hi @Julia C Peterson

If you've added the sheet to the Workapp as a Smartsheet Item, then no, there currently isn't a way for your users to create filters within the Workapp directly. You would need to set up Shared filters ahead of time to give them options to choose from.

That said, you can add a Published version of your sheet to the Workapp as a Web content link, which would allow your users to create filters as-needed on the Published version. See: Publish a Sheet, Report, or Dashboard

Please provide your feedback to the Product team through this form, here.

Thanks!

Genevieve

Weston Johnson · 03/29/23

Work APPs is completely useless for our needs we must be able to filter in the sheet. I would suggest changing the setup.

Joseph Gentile · 04/06/23

I couldn't agree more! This is an easy win for Smartsheet. Just enable the same filter functions as a "View Only" shared sheet to WorkApp. Help us #WorkSmarter 😉

SWAus · 07/24/23

https://community.smartsheet.com/discussion/comment/369401#Comment_369401

This type of thing seems to be a typical dead end I am landing on with smartsheet. I always seem to find a 95% perfect solution then stumble on a 5% that makes the entire thing unusable.

Unlicensed users can make their own filters, Tick.

You can make a workapp so all the sheets a user needs for this task are in one nice location, Tick.

Users go to use the workapp, need to filter but they can't, cross.

Unknown · 09/19/23

This content has been removed.

Geilisa · 10/04/23

This is still a big problem. I need certain user rolls defined in the work app to see certain sheets, be able to make edits and filter.

Philip Selzer · 11/01/23

i could not agree more. this NEEDS to be a functionality for workapps to be functional.

End users able to create their own filters on sheets in WorkApps?

Answers

Categories