Help

Feature request: Lookup without duplicates

Topic Labels: Base design
1000 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaley_White
6 - Interface Innovator
6 - Interface Innovator

I need unique lookup values. This can only be done using a rollup field, which removes formatting. I need unique values but retained formatting.

Lookup field: Contains duplicates

Kaley_White_0-1680115338848.png

Rollup field: No formatting

Kaley_White_2-1680115466826.png

What I need: Lookup field w/ duplicates removed

Kaley_White_1-1680115409708.png

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi Kaley,

A way to use ARRAYUNIQUE() in a lookup field to dedupe values would be a great addition to the product. You're right! You can do this with a rollup field, but it does remove the formatting. I encourage you to post this idea in the Product Ideas section as I am sure others might be looking for similar functionality.