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.

Duplicated Content in Lookup

Topic Labels: Formulas
Solved
Jump to Solution
1910 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Casey_Martell
5 - Automation Enthusiast
5 - Automation Enthusiast

Has anyone seen duplicated content resulting from a Lookup?

I’ve noticed this in a couple different tables and it is causing formula errors for me.

For example, I have a lookup on a single select field with only these options: http://photoville.org/uploads/2020-08-05_073451_3zvyyjo.png

Yet, in the resulting field, there are sporadic entries that appear as ‘Clinical Trial, Clinical Trial’

When I subsequently attempt to use this field in a Switch(), I get ‘#ERROR!’ in those case where the entry is duplicated.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

Thank you, that totally was the problem, and a nice solution!