Skip to main content

Searching/Filtering by multiples email addresses

  • April 27, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+3

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

TheTimeSavingCo
Forum|alt.badge.img+28

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" )

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

 


Reply