Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 27, 2022 09:27 AM
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!
Solved! Go to Solution.
May 27, 2022 05:18 PM
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})
),
", $",
""
)
May 27, 2022 09:55 AM
To do this simply
A&B&C&D
May 27, 2022 05:18 PM
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})
),
", $",
""
)
May 30, 2022 08:23 AM
Thank you so much @kuovonne !!!
Nov 01, 2023 01:45 PM
Hi I have field