Enhancement Request: Default, Locked, Export Filters

J. Craig Williams

Thank you very much for the New Row Filters released yesterday.

This will free up several Zaps (www.zapier.com) that I sometimes use. 

Here's what I want next:

LOCKED FILTER

As either Admin*, be able to lock a filter. One and only one filter can be locked at time. The filter is automatically shared. Non-Admin users can not unlock the filter.

Data filtered out can not be exported or viewed by non-Admin users in any way (and there are currently many ways a users can see the data). This includes hidden columns.

This would provide a way to provide access to sheets but hide more of the data that is currently exposed. This is more of security issue than a convenience issue.

The Locked Filter is also the ...

DEFAULT FILTER

As either Admin*, be able to set a filter as the default view. One and only one filter can be the default at time. The filter may or may not be automatically shared. (I'm on the fence about that)

When the Sheet is first opened, the default filter is used. 

For Shared Filters, the issue is whether and how much the Admin* can control the end-user experience. Setting a default filter for the Sheet (as opposed to my view of the Sheet) will help the Admin* standard the end-user's use of the sheet.

I know for my experience, I can set the filter and close the sheet and that is what I will see when I open it back up. But I'm lazy and it isn't only my sheet usage I need to the think about.

Lastly, I would like to be able to

EXPORT FILTERS

I have lots of filters. Lots. Dozens sometimes depending on the Sheet's content. I would like to be able to Export the filter (name, criteria, is it shared, etc...). I need some easy way to document for my users the filters that are pre-made for them.

A minor note on what I mean by Export. I don't want the Export to csv. I want to Export to a Smartsheet Sheet. I may have written about that elsewhere. If not, I will, someday.

Even more lastly, 

ADD FILTERS TO FUNCTIONALITY LIST in the Community Post.

Again, thanks for improvements. 

Craig

*Admin. When I say Admin, I also mean these are Owner privileges on the Sheet and not the usual Admin. This goes against my usual "too many choices to check for whether I can do or not do something", but in this case, it might make sense. I can make arguments for either Owner or Admin. The longer it takes to write this, the less convinced I am that Owner is the way to go.

This request has also be posted to the Form

 

Mike Wilday

Criag, when you mention default filter -- do you mean a filter that is automatically applied to everyone's view of the sheet?

jrfish1001

YES! Please give us this feature.

Mike Wilday

@jrfish1001 Submit an enhancement request to add your vote. 

jrfish1001

After the UX "upgrade" I've lost faith that smartsheet really cares about what features users actually want. But I guess can't hurt, right?

 

 

Mike Wilday

Nope, not unless those few minutes are a detriment to your day. They don't use the community as a resource for looking up user requests. They only consider enhancement requests that have been submitted to their system and direct complaints from customers (although I don't see a lot of proof of that). 

diane.reddick40501

I want this enhancement myself