Skip to main content

Deduplication in Lookup Field?

  • September 21, 2020
  • 2 replies
  • 0 views

Forum|alt.badge.img+8

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!

2 replies

Forum|alt.badge.img+18

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)

Forum|alt.badge.img+8
  • Author
  • Known Participant
  • 25 replies
  • September 21, 2020
Jeremy_Oglesby wrote:

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!


Reply