Forum Discussion
Filter doesn't work
Hi all,
I'm having issues with a filter. In one sheet the filter shows all contents in the column and you can switch on/off some of the contents. In another sheet (which is in basic almost identical) the filter doesn't show the words in the column. See screenprints below.
Whats is wrong? I have checked all sorts of things in the sheet and searched the internet, but cannot find it. Is there someone here who can help?
4 Replies
- Riny_van_EekelenPlatinum Contributor
whugos I suspect that in the left hand example you put a filter on a column where the first row is empty.
without he empty row it looks like this:
Screenshots are taken on a Mac, but it's quite similar on the PC.
- whugosCopper ContributorThanks Riny, I have checked, but unfortunately this is not the case in my sheet.
- SergeiBaklanDiamond Contributor
It's desirably to have bity more information to what and how filters are applied. For example, here
filter applied to left and right Name have same behavior as on your left and right screenshots.
- whugosCopper Contributor
I do understand that I provided a few information, but I find it difficult to know what other information is usefull.
What I find hard to understand is that in the "old" sheet there is text in the filter and in the "new" sheet, which is basically build in the same way there isn't any text.