Skip to main content

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})

  ),

  ", $",

  ""

)

Thank you so much @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})

  ),

  ", $",

  ""

)

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 ? 

Reply


Terms & Conditions