Is there a way to set up a lookup field without duplicates?
Removing duplicates from lookup fields?
+1This topic has been closed for replies.
+17Hi @Y_S
Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates
+1Hi @Y_S
Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates
Hmm what should I put in the formula box?
+17Hmm what should I put in the formula box?
Just like that it should work
+17Turns out i needed to do like this for it to work
Yes, you shouldn’t have removed “values” from inside the bracket, I didn’t notice it in the first screenshot :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.