Forum Discussion

whugos's avatar
whugos
Copper Contributor
Feb 19, 2022

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

     

    • whugos's avatar
      whugos
      Copper Contributor
      Thanks Riny, I have checked, but unfortunately this is not the case in my sheet.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    whugos 

    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.

    • whugos's avatar
      whugos
      Copper Contributor

      SergeiBaklan 

      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.

Resources