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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.