ArrayFormula(TEXTJOIN) in Googlesheets is not...

Sebastien_Senel · 04-10-2018 05:00 PM

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

Mary_Jane_Pende

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

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

Sebastien_Senel

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!

Soufiane_M

I have the same problem , I AM looking for an équivalent to TEXTJOIN on appsheet . can someone help us !

Steve

There is no direct equivalent. The closest workaround would be a combination of CONCATENATE() and SUBSTITUTE():

SUBSTITUTE(
  CONCATENATE(list-of-values),
  " , ",
  "separator-text"
)

Which, if I understand_TEXTJOIN()_ correctly, is equivalent to:

TEXTJOIN("separator-text", FALSE, list-of-values)

It’s possible to remove empty values as well, but a side-effect of the process will also remove duplicate values:

SUBSTITUTE(
  CONCATENATE(
    list-of-values
    - LIST("")
  ),
  " , ",
  "separator-text"
)

Which is the closest-but-definitely-not equivalent to:

TEXTJOIN("separator-text", TRUE, list-of-values)