Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Filtering Email Combinations to Exclude Empty Cells: Need Help! | Clay

Filtering Email Combinations to Exclude Empty Cells: Need Help!

·Oct 14, 2024 09:28 PM·

Hi guys when trying to filter the column ''email combination'' by using is not empty, it also shows the empty cells. Can you help ?

7 comments

· Sorted by Oldest

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Carlos L.
·
·
Workspace : https://app.clay.com/workspaces/279801/tables/t_rx8tpwXHNQyK/views/gv_b9JTDKzzTHnb
Bo (.
·
·
Hey, thanks for reaching out! 😊 It seems like the “Email combination” field isn’t truly empty. There might be spaces or some hidden characters causing the issue. I found that when you change the field type to email, it shows an error. To fix this: 1. Go into the affected cells and manually delete the value (click on the cell and hit delete). 2. Refresh the page so it can recalculate, and it should work properly. Let me know if that helps! 😊 https://downloads.intercomcdn.com/i/o/w28k1kwz/1215871792/f7b1e645d9736a0dbb639bbaf16d/CleanShot+2024-10-14+at+_31WzGcmp4V%402x.png?expires=1728944100&signature=688f911a6af5230be14be11626b6aaed56a3b62ff505b46744e38a03ffa2c89c&req=dSImE8F5nIZWW%2FMW1HO4zUiRVKqmdX1h7XoY42L1tPP%2BrlFLHkOP6jzDQa9Q%0AChmU%0A
Bo (.
·
·
Here's how to do it fast :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1215873372/24b6ac8bd61c8f8d4baf888a78e3/CleanShot+2024-10-14+at+_08vStrCRZi.gif?expires=1728944100&signature=da492b818015c567dc637efe955d92b6d47445ac179b58ff4ac4eb3eb015f004&req=dSImE8F5noJYW%2FMW1HO4zQN3bSFjMKJwC7iSa0ovhjHn6wPV%2F%2B9EVslVZTGG%0ACGFz%0A
Carlos L.
·
·
Bo you are the best 👌
Channeled
APP
·
·
Hi Carlos L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Carlos L.!