Deduplication in Lookup Field?

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).

Thank you!

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)
1 Like

That worked! Thank you!

image010.jpg

image011.png

image012.jpg

image013.png

image014.jpg

image015.jpg

image016.jpg

image017.png

image018.png

image001.jpg

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.