Help

Removing duplicates from lookup fields?

86 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to set up a lookup field without duplicates?

image

5 Replies 5

Hi @Y_S

Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates

Hmm what should I put in the formula box?

image

Just like that it should work

Turns out i needed to do like this for it to work
image

Yes, you shouldn’t have removed “values” from inside the bracket, I didn’t notice it in the first screenshot :slightly_smiling_face: