We have a large spreadsheet that is shared with about 50 individuals each day. Different users are looking at different items and updating specific status events.

When we were working in Google Sheets, there was a 'filter view' functionality that would allow individual users to set up their own view that would not be impacted by other users moving around on the sheet. Does Sharepoint have anything similar?

  • What version of SharePoint you are using? SharePoint online/2019/2016/2013? – Ganesh Sanap May 14 '19 at 16:54

Not sure if this is what you are asking but your users should be able to edit the view of the list, filter columns and such and once they have that setup how they like it they can click on the following to save the view.

Save SharePoint List View

They should then be prompted for a view name and if the view should be made public or not. Once saved they can access the view from the drop down above by selecting it.

Thanks, Zach

| improve this answer | |

I don't know all your requirements.

But if you want to create a view and filter the data depend on the current logged in user then you can use [Me] in filter.

Or If you want to create a view in list which will be visible to only you then you can create a personal view on SharePoint list. (You can check for maximum number of personal views can be created per SharePoint list).


  1. Filter views based on current logged in user.

  2. Create personal view in SharePoint list.

  3. Limitations on number of views per list.

| improve this answer | |
  • Does this answers your question or it helped you in any way to get the solution? – Ganesh Sanap May 16 '19 at 10:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.