ArrayFormula(TEXTJOIN) in Googlesheets is not...

(Sebastien Senele) #1

ArrayFormula(TEXTJOIN) in Googlesheets is not matching in Appsheet. How can I replace this formula?

(Mary Jane Pender) #2

Hi Sebastien, I would suggest using CONCATENATE function.

Check out the Support documentation to see how concatenate is formatted.

Hope this helps.

mj

(Aleksi Alkio) #3

With the TEXTJOIN you can specify the delimiter but with the CONCATENATE you need to write them one by one.

(Sebastien Senele) #4

Hi, my formula is

=ArrayFormula(TEXTJOIN(", “,TRUE,IF(‘Order details’!$B:$B=$A64,‘Order details’!$A:$A,”")))

I can use it in Appsheet. Is it right? Thanks Mary Jane and Aleksi for your support!