Solved

Can you filter out blank fields in custom view

  • 27 January 2023
  • 2 replies
  • 35 views

Badge

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.

icon

Best answer by nburke 30 January 2023, 20:48

View original

2 replies

Userlevel 4
Badge +4

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.

Userlevel 7
Badge +12

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

Reply