Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Removing duplicates from lookup fields?

182 5
Showing results for 
Search instead for 
Did you mean: 

Is there a way to set up a lookup field without duplicates?


5 Replies 5

Hi @Y_S

Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates

Hmm what should I put in the formula box?


Just like that it should work

Turns out i needed to do like this for it to work

Yes, you shouldn’t have removed “values” from inside the bracket, I didn’t notice it in the first screenshot :slightly_smiling_face: