Clay Icon
Join the Community
02 Support

Issues with Clay filters in Peoples Table: Empty cells not recognized as empty when filtering out companies without SDR

Avatar of Niko N.Niko N.
·
·

Some filters in Clay are not working. In my peoples Table i am trying to filter out all companies that have no SDR but it seems that the filter is not working cause cell that are empty are not recognized as empty

7 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Niko, thanks for reaching out! Taking a look

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    There we go, you should be able to apply a filter now. I updated the field it was extracting so it gets rid of the "empty space" value it printed for those rows. This actually came from your original table, looks like over there it's combining full name with a " " space in between them of course -> Example: {fname} + " " + {lname}But for rows that don't have any values it still adds the empty space and that's what your lookup integration pulled instead, and why it was not considered as empty. Hope this helps!

  • Avatar of Niko N.
    Niko N.
    ·
    ·

    Great thanks !

  • Avatar of Niko N.
    Niko N.
    ·
    ·

    which field did you updated exactly? just want to know how you did it so that i can avoid the issue in the future.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Sorry for the delay! I updated this column's formula "Full Name SDR Final P"

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    I asked it to check if the Lookup's result had an empty space instead of a name, if it did then it shouldn't return anything and remove the space in the final column. Otherwise, it will return the name