ArrayFormula(TEXTJOIN) in Googlesheets is not matching in Appsheet. How can I replace this formula?
Hi Sebastien, I would suggest using CONCATENATE function.
Check out the Support documentation to see how concatenate is formatted.
Hope this helps.
With the TEXTJOIN you can specify the delimiter but with the CONCATENATE you need to write them one by one.
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!