FilterByFormula - Exact match for Multi-Value Colu...

[Eddy_Maaya]

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!

[Vivid-Squid]

To do this simply

A&B&C&D

[kuovonne · Accepted solution]

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]

Thank you so much @kuovonne !!!

[KuboS]

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 ?