Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 02:45 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 04:42 AM
Hi @Dean_Arnold - what is the formula you are using? This works for me:
with formula:
ARRAYUNIQUE(Lookup)
