Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Getting Values from 4 columns

Solved
Jump to Solution
1469 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Eddy_Maaya
6 - Interface Innovator
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
kuovonne
18 - Pluto
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})
  ),
  ", $",
  ""
)

See Solution in Thread

4 Replies 4

To do this simply

A&B&C&D

kuovonne
18 - Pluto
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})
  ),
  ", $",
  ""
)
Eddy_Maaya
6 - Interface Innovator
6 - Interface Innovator

Thank you so much @kuovonne !!!

KuboS
5 - Automation Enthusiast
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 ?