Help

How to filter empty rows?

Topic Labels: Formulas
2229 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Juan_Pedro_Paz_
4 - Data Explorer
4 - Data Explorer

Is there a simple way (in free version)?

1 Reply 1

Do you want to filter to see only empty rows, or do you want to filter to hide empty rows?

How many fields do you have in your table?
If you want to see only empty rows, set the filter where each of the editable fields “is empty”. Use “and” to combine the conditions.

If you want to exclude empty rows, set the filter where each of the editable fields “is not empty”. Use “or” to combine the conditions.

If you have too many field to include all the editable fields in the filter, use a formula field to test if any fields have have values, and then filter on the formula field.