Summary
This video looks at how to return all the values if the filter criteria is blank.
Tab in example file: Filter all
Using OR logic (i.e. addition with arrays of TRUE/FALSE) in combination with ISBLANK returns all the values if the filter value is blank.