You could do that if {Recipients} is either a Rollup or a Lookup field.

If the {Group #} field is a LinkToAnotherRecord type field pointing at the table [Groups], then the [Groups] table could have a Lookup type field pointing at your [Customers] table’s {Email} field. This will give you all the emails associated with that group.

A lookup wouldn’t combine multiple values into the same cell, would it?

I’ll give rollup fields a try.

Hi @Kamille_Parks, I’m only seeing numerical calculations…so that’s not quite what I am looking for. To be clear, I’m looking for a list of emails not the number of emails.

Yes, Lookups list the value of a particular field for each linked record in a single cell. If you want to use a Rollup field use any of the Array functions.

Hi @Kamille_Parks, could you please provide some more detail? I don’t know if I want to use a Rollup field. Is there a good example of using a formula to pull email addresses into a single field out there that you’ve seen?

We’re going to walk through this step by step. Have you made the {Group #} field a LinkToAnotherRecord type field?

You know what nevermind about step by step, since its only two steps. Just replicate what you see here:

(I used a Lookup field but again you could do the same with Rollups)

Hi! Could you please reopen the link so I can use it as well?

@Kamille_Parks11I would also really like to use this solution, if you're able to reopen the link! Thank you!

This thread is 3 years old, that demo base is long since deleted.

This is a textbook example of when to use a lookup field. Based on the description of the original problem, all I likely did was make a table for Groups, linked each Customer to the appropriate group with a Link to Record field, and in the Groups table add a loop field. Review Airtable's documentation: 

https://support.airtable.com/docs/lookup-field-overview