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!
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!