Recent

SharePoint filtered view is not working

When creating filtered views on SharePoint lists or libraries, sometimes items that shouldn’t appear in the view do appear with filters that combine both AND and OR conditions together.  For example here’s an example of a filtered view where I wanted only items with the word test in the title, and in either Pending and In Progress status.  The problem is an item without the word Test in the Title is returned in the view:
Troubleshooting-filtered-views-16-1

The problem is the order of conditions determine how the the SharePoint filters work.

Solution

When combining OR and AND conditions together, put the OR condition(s) before the AND condition(s):
Troubleshooting-filtered-views-16-2

More Information

For more information on setting up filtered views with multiple conditions:
Filtered Views with Multiple Conditions tutorial

OR you can use a Calculated Column to simplify filtered views:
Filtered views with Calculated Columns tutorial

About Nick Hurst (84 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: