Help

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

Deduplication in Lookup Field?

Topic Labels: Formulas
302 2
cancel
Showing results for 
Search instead for 
Did you mean: 

As you see in my lookup field, certain names (Mickey, Annie, Codi) are listed twice, since they’re responsible for multiple steps within one objective.

How can I either create another field or change that lookup field so it’s displaying unique step owners (associated with steps).

image

image

Thank you!

2 Replies 2

Hi @Rachael_Castelaz

I think if you change that field to be a Rollup field instead, you can use the following aggregation formula to get only unique values:

ARRAYUNIQUE(values)