# Getting Values from 4 columns

Solved
Jump to Solution
1057 4
cancel
Showing results for
Search instead for
Did you mean:
6 - Interface Innovator

Hi All,

Wanted to ask for help on how I can approach this.

I have 4 coulmns (A, B, C, D) - I want to check which columns are not empty.

Example, A has a value (Apple), B, C are empty, D has a value(Orange)

I have another column called Summary. I want to display columns that have value. In the example, I would like to display Apple, Orange.

Your help is appreciated.

Thanks!

1 Solution

Accepted Solutions
18 - Pluto

Welcome back to the Airtable community!

There are multiple ways of doing this, especially getting the commas and spaces right. Here is my current favorite methods.

``````REGEX_REPLACE(
CONCATENATE(
IF({A}, {A} & ", "),
IF({B}, {B} & ", "),
IF({C}, {C} & ", "),
IF({D}, {D})
),
", \$",
""
)
``````
4 Replies 4
11 - Venus

To do this simply

A&B&C&D

18 - Pluto

Welcome back to the Airtable community!

There are multiple ways of doing this, especially getting the commas and spaces right. Here is my current favorite methods.

``````REGEX_REPLACE(
CONCATENATE(
IF({A}, {A} & ", "),
IF({B}, {B} & ", "),
IF({C}, {C} & ", "),
IF({D}, {D})
),
", \$",
""
)
``````
6 - Interface Innovator

Thank you so much @kuovonne !!!

5 - Automation Enthusiast

Hi I have field

SUM(Capacity-CONCATENATE({🪑 Attendees}))
Column capacity has number 3
Column Atendees has entries A B
I need tu by result 1 as (3-2)=1

Please any Idea ?