Help

Getting Values from 4 columns

Solved
Jump to Solution
183 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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})
  ),
  ", $",
  ""
)

See Solution in Thread

3 Replies 3

To do this simply

A&B&C&D

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})
  ),
  ", $",
  ""
)

Thank you so much @kuovonne !!!