Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula output not including commas from lookup fields

Topic Labels: Formulas
1363 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dean_Arnold
7 - App Architect
7 - App Architect

Screenshot 2020-05-18 at 5.42.03 PM

Hi there,

If I have a formula that uses values from a lookup field (which has more than one value from another table), the formula doesn’t recognize or include the commas from the lookup fields. Does anyhow know the solution? I’m trying to get to a Unique array formula which won’t be possible if my values aren’t separated by a comma.

Thanks!

1 Reply 1

Hi @Dean_Arnold - what is the formula you are using? This works for me:

Screenshot 2020-05-18 at 12.42.22

with formula:

ARRAYUNIQUE(Lookup)