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 ?
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 ?
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 !!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.