I have an automation set up that loads Google Calendar meeting info into my database, including attendee email addresses.
What I want to do is extract the emails of only the people who are not internal employees. That is to say, extract all emails in...
Thanks so much for the help! It seems to work perfectly except for 1 thing: If the company email address is not the first email in the list of populated emails, it also erases external email addresses before it, leaving a blank result.
Hi Adam, I used your formula and unfortunately got an error message saying “Invalid formula”. I replaced Name for the field/column name I want to reference, “Attendee email list”. Is that correct?
I appreciate the help and it seems to have worked so thank you.
However, I realized there’s a. second email domain I also want to filter out. So I want to filter out those ending in “@company.com” and “@group.calendar.com”. Is there any way I could f...
I seem to understand how that pulls data for that particular string but want I want to do is, in a separate column/field, is list the participants whose emails are not from the company domain.
