Help

Searching/Filtering by multiples email addresses

Topic Labels: Data
548 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Haley_Lopez
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, if I have a spreadsheet with a long list of emails, and I need to search those email on my base, is there a way to search/filter all emails at one time or do I need to search 1 by 1? I've tried to filter by emails address and pasting all the address in the "contains" value but it doesn't bring anything up, same with the simple search?

Thank you!

1 Reply 1

Hmm, you could try:
1. Create a Long Text field called "Emails to find" or something
2. Copy the list of emails you need to find
3. Click the header of the "Emails to find" field and paste in the emails
3. Create a Formula field with the formula

 

IF(
  FIND(
    Email,
    {Emails to find}
  ),
  "Email found"
)

Screenshot 2023-04-28 at 11.05.24 AM.png

Depends on what you're trying to do though; lemme know if this doesn't work for you