Deduplication in Lookup Field?

[Rachael_Castela]

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!

[Jeremy_Oglesby]

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)

[Rachael_Castela]

That worked! Thank you!