Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How can I gather different values in one cell?

Solved
Jump to Solution
223 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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?Screenshot 2022-12-01 at 10.53.24 AM.png

Thank you very much!

1 Solution

Accepted Solutions
goksan
6 - Interface Innovator
6 - Interface Innovator

Hey Ana 👋

You could make use of CONCATENATE

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

See Solution in Thread

5 Replies 5
goksan
6 - Interface Innovator
6 - Interface Innovator

Hey Ana 👋

You could make use of CONCATENATE

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

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

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. 😞Screenshot 2022-12-01 at 12.05.42 PM.png

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

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