We added a filter to our list to avoid reaching the view threshold (original question was here: SharePoint List View Filter display 1 week) but despite the filter being active (currently the view is showing 11054 items) when I go to list settings it says 12656 items and a warning that we're reaching our limit of 20000. Why the difference in numbers? Is it because I didn't index the [Created] column?

1 Answer 1


View Filters do exactly what they are called - filter the total list items and only return those filtered items to the View.

So by setting a view filter, you are not reducing the total amount of list items, you are only specifying the criteria for which list items actually get sent to the View in the browser.

My guess is that the warning will still show because SharePoint is assuming that you may be using an unfiltered (All Items) view.

  • I added the filter to the All Items view. Should I create a custom view and add the filter there? Dec 22, 2016 at 22:14
  • 1
    Personally, as a best practice, I would, that way I know All Items is really All Items, and you can name the filtered view in a descriptive way. (And set it as the default view.) In terms of the warning, though, I don't think it matters. SharePoint doesn't really know what's going on with your views, so it has to assume there's an unfiltered one somewhere. Dec 22, 2016 at 22:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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