Getting Values from 4 columns

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!

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

Thank you so much @kuovonne !!!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.