Filter for Column Type "Date" only functions on the Sheet and not Report
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!
Help Article Resources
Check out the Formula Handbook template!