Gathering Data from 1 Table into Another

[anaclara]

I've done a few things in Airtable, but have lots to learn still. I'm creating a database with the contacts across all my organization. We would like to keep track of individuals who work in several organizations, so we have one field for ORG 1 and another for ORG 2. We would like to see all the ORGs a person is involved in at the field ALL ORGS. (See image)

How can I create a formula to include ORG 1 and ORG 2 values in ALL ORGs field?

Thank you very much!

[goksan · Accepted solution]

Hey Ana 👋

You could make use of CONCATENATE

CONCATENATE({ORG 1}, ", ", {ORG 2})

[goksan]

Here's the formula reference if you haven't already seen it - https://support.airtable.com/docs/formula-field-reference

[anaclara]

Thank you for your prompt response, goksan. But it didn't work...maybe because my values are not numbers, but names? I got a "NaN" response as the result. 😞

[anaclara]

I missed this message. It worked! Thank you so much!

[kuovonne]

The concatenate operator in Airtable formulas is & not +. Try replacing + with &