Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

ArrayJoin formula doesn't deliver requested separator

Topic Labels: Sync
343 2
Showing results for 
Search instead for 
Did you mean: 

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 2

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

worked like a charm ! Thank you !!!