Skip to main content

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


Hi @Y_S


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


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?



Hmm what should I put in the formula box?



Just like that it should work


Just like that it should work


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


Turns 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 🙂


Reply