Skip to main content

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)

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