Hello. I hope you’re well and in good spirits.
I created a filter using the date column and the category column. I set the criteria for Date to “between 12/31/2021 and 8/1/2022”. Then I set the Category to “Utility-Gas OR Utility-Electric”.
It worked beautifully!
The bizarreness: I’m creating another filter with the same criteria for Date; for Category I’m prescribing “Groceries OR Dining out”.
It doesn’t work at all!
This time all it does is hide every single row except the last four in the sheet (which are blank ones). Why the different result? The only thing I’m doing differently for this new filter is asking for different categories.
When I created this filter with NO specification for Date (that is, I left that column alone), it did select the rows that were either Groceries or Dining out. So I know that part of the filter does work.
There’s something fishy going on with the Date part of the filter.
What do you think it might be?