Help

Concatenate Problem

Topic Labels: Formulas
Solved
Jump to Solution
6431 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi everyone! I hope you had an amazing Thanksgiving!

I have some problems with my formula, I'm trying to concatenate two columns (see attachment ). As you can see, the Calculation column missed the "commas" of the originals columns, and moreover, if there is anything in a column, it adds a comma.

I would like that my calculation is :

1 Report Name2- Report NameCalculation
D, EC, FD, E, C, F
F, CF, C
D, ED, E

my formula is in the attachment.

What am I doing wrong?

Thank you very much!

12 Replies 12

Base I created a "fake" base, so you can try it if you want. Thank you very much!

Hi Sara! Thank you very much for creating the base for me!

Screenshot 2022-12-06 at 12.09.00 PM.png

I added kuovonne's original solution about the `ARRAYJOIN()` to the formula and I think it should be what you're looking for

```

IF(
AND(
ARRAYJOIN({1- Report Name}),
ARRAYJOIN({2- Report Name})
),
ARRAYJOIN({1- Report Name}) & "," & ARRAYJOIN({2- Report Name}),
IF(
ARRAYJOIN({1- Report Name}),
ARRAYJOIN({1- Report Name}),
ARRAYJOIN({2- Report Name})
)
)
```

It works😍!! Thank you very much!! I really appreciated it! 😀