Filter view when SharePoint list item is not blank
It is possible to create a list (or library) view where content of a column item is blank, but I haven't found a good way to create a filter when a list column item is not blank. Eg. I want to create a weekly project status report by using a SharePoint list, where we include "celebrations" as a multiple lines of text field. In this list I want to make a view where only those items where "celebrations" has text shows. Any good ideas how to do this, or make this functionality available? Please! :-)
You should be able to do ad-hoc filtering on "blank" for one or more columns without having to change the list settings.
In my SharePoint 2016 using any of the qualifiers such as is greater than, is not equal to, etc. only works on numeric fields. This does not work on text columns. Is there a way to change a setting so that they will apply to all types of metadata?
Steve Hancock commented
I have the same issue with users not keen to create multiple views they are looking for a 'not empty' choice on the filter drop down.
In the Filter section of the Edit View, for "Show the items when column" should include options _is empty_ and _is not empty_.
Mike Gusway commented
Use the filter set this way:
Show the items when column
(celebrations) selected from drop-down
is not equal to
(leave this field blank)
You'll find that it will only display items that have content (are not blank) in your Celebrations field.