sharepoinTony

@info – The practical side of SharePoint

List View Filtering

Posted by sharepoinTony on September 10, 2009

 
Here is something that I had to figure out that may help others…

Looking for NULL’s:
In your view, for the filter choose:

“Show items only when the following is true:”
then “Show the items when column”
Select from the dropdown [name of your column that can be blank]”
choose “is equal to”
then leave the text box blank.

  See my example using a blank Due Date:

 Filter within a List View

Filter within a List View

 

 

 

 

Going back to your list, if you now use this view, it’ll only return results where the column is empty.

 

Filtering a View for a SharePoint List

Advertisements

Sorry, the comment form is closed at this time.

 
%d bloggers like this: