I’ve looking through a few others threads and haven’t found a solution so I’m hoping the hive mind can help: a bit of a tricky scenario, but I’m essentially looking for a way to compare comma-separated emails across two cells and identify the ones without a match.
Scenario: I have an airtable of events, where each event has:
- a column called “invitees” (people invited to an event), where multiple email addresses are separated by commas within a cell – the values are a string
- a column/cell of emails called “RSVP’s” (people who have already replied ‘going’), where multiple emails are separated by commas as well – the values are a array that rolls up data from another table.
So we’ve got two comma separated cells, one is a string and one is an array.
I would like to send reminder emails only to the people on the invitee list who did not already RSVP (aka, remove RSVP emails from the invitees list, then email only the ones left over, aka the ones without duplicates). Is there a way of doing this without creating new columns for each email address?
Thanks for any help you can provide!
I thought I could turn them into arrays and somehow compare them, but I doubt there’s a way to do a compounding if statement for each item in the array, similar to a for loop in php (e.g., if [columnA arrayvalueA] is in columnB, don’t list it, else list it; if [columnA arrayvalueB is in column B, …]. It seems beyond airtable’s formula capabilities.