Skip to main content

I was setting up a custom view and I wanted to exclude assets that were missing a value in a specific column I couldn’t seem to figure out how to exclude rows with null values.

You could create your view and when you choose that custom field as a filter, you can then go into your Settings, filter that custom view, and choose all the categories or items you want but then choose EXCLUDE SELECTED at the bottom.  That way it will give you the result of anything but those that were chosen-which should be all your blank ones.


@nburke Thanks for jumping in and suggesting this work around! Great job!


Reply