Sharepoint Lists - Filter Select All

Question

Simple question.

I have a list with many records and a "calculated column". I want to filter this column by selecting all data which is not 0. I mean, i would like to select all and the remove the ONLY value i don't need. This should be the expected behaviour in productive applications.

There any way to do it without creating other views? I would expect a button like "Select all"

Answer 1

Dear Marco Corsetti,

Greetings! Thank you for posting in Microsoft Community. We are happy to help you.

As far as I know, I'm sorry and I'm afraid there is no built-in feature in SharePoint list to create a "Select all" button as you described. Sorry for the inconvenience.

By the way, if you want to filter the current view of your SharePoint list so that only data that is not 0 will display, then you may try editing the current view and applying a Filter for that calculated column.

1.In your SharePoint List, click All Items and choose Edit current view.

2. Scroll down to Filter, choose Show items only when the following is true, select your calculated column, is not equal to 0. Then click OK on the bottom to save this setting.

However, if this is not what your want, I apologize for the inconvenience.

I sincerely recommend you try posting a question in the Microsoft Q&A Communityand asking for customized solution which can meet your requirement. Members and engineers over there are proficient in the knowledge of SharePoint customization and development queries. They will focus on the specific situation on your side and provide specific suggestions for you.

Thanks for your time and understanding!

If my understanding of the scenario is not consistent with yours, feel free to point it out, I will continue helping you.

We hope you have a nice day. Stay safe and healthy always.

Sincerely,

Tina | Microsoft Community Moderator

Answer 2

Hello Tina,

Thank you for your response. I've tried your suggestion and it works, but only as a temporary workaround, considering that I have 6 calculated columns, which would mean creating 6 different views, one for each column.

I'll go back to using Excel, as it already has this function integrated, while waiting for Lists to become more than just a half-baked solution and finally be usable as a productivity tool for real work life.

Regards,

Marco