Filter for Column Type "Date" only functions on the Sheet and not Report

NHop

I have a column in a Sheet that contains dates. This is the source data for a shared Report. I would like the report to filter only rows where this date column is blank, however if I make the column type to Date, the filter condition "is blank" only functions as expected on the Sheet and not the Report.

The Sheet correctly filters to show only rows where that column is blank. The Report view removes all rows.

The filters work correctly on both the Sheet and Report if the column type is "Text/Number" - however that limits another filter I'm wishing to use that requires the column type to be "Date"

Thanks in advance for any thoughts!

Eric Law

@NHop Please share screenshots of the report with the filters open. Also, a screen shot without filters too.

ker9

Hi @NHop

On your Date Column in your Report you are unable to filter using "is blank" - like this? ("Dates" is my date column).