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

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

Is there a way to set up a lookup field without duplicates? I asked this here and I just noticed that the response didn’t fully solve the issue: The rollup formula ARRAYUNIQUE(values) still includes duplicates.



5 Replies 5

I’m not 100% sure if this will work, but you may want to try this formula to see if it works for you:


Hmm this doesn’t do the trick. Any other suggestions?

Add a formula field containing ARRAYUNIQUE({Purpose (from Interventions}). This should work.

Read this discussion. May be this can help you here If yes then please mentioned me here.

Well I had the same question becasue of same issue. Thank you to Scott for the answer