Solved

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!

Best answer by kuovonne

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

+16

To do this simply

A&B&C&D

+29

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 !!!

+3

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

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 ?

Sign up