Help

Deduplication in Lookup Field?

Topic Labels: Formulas
1118 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachael_Castela
6 - Interface Innovator
6 - Interface Innovator

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)

That worked! Thank you!

image010.jpg

image011.png

image012.jpg

image013.png

image014.jpg

image015.jpg

image016.jpg

image017.png

image018.png

image001.jpg