+1I'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!
Best answer by goksan
Hey Ana 👋
You could make use of CONCATENATE
CONCATENATE({ORG 1}, ", ", {ORG 2})
+6Hey 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
+1Thank 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. 😞
+1Hey Ana 👋
You could make use of CONCATENATE
CONCATENATE({ORG 1}, ", ", {ORG 2})
I missed this message. It worked! Thank you so much!
+29Thank 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. 😞
The concatenate operator in Airtable formulas is & not +. Try replacing + with &
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.