Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: ArrayJoin formula doesn't deliver requested separator

867 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Liberchuk
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Alex_Liberchuk
5 - Automation Enthusiast
5 - Automation Enthusiast

worked like a charm ! Thank you !!!