Skip to main content

ArrayJoin formula doesn't deliver requested separator

  • June 4, 2021
  • 2 replies
  • 30 views

Forum|alt.badge.img

I have Lookup Field (“Status”) that has many records with multiple values per cell. I want to parse out these values using ARRAYJOIN(Status," | "). It only returns me the comma-separated values , without “|”.

Any thoughts ?

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • June 4, 2021

Use your formula in a rollup field based on the same linked record and referenced field as the lookup.


Forum|alt.badge.img
  • Author
  • New Participant
  • June 4, 2021

worked like a charm ! Thank you !!!