Matching part of a user-list to another user list

I have two list-user fields - List1 and List2 I want to compare these two fields in a formula-checkbox field and have the result be true if ONE OR MORE user(s) from list1 appears in list2. Examp...

ChayceDuncan

Qrew Captain

It's not ideal - but you'll essentially have to break out list1 and see if any of them exist in list 2 using a combo of functions. Best I can come up with quickly is:

var text list1 = ToText(UserListToEmails([user list 1]));

Includes([user list 2],ToUser(Part($list1,1,";"))) or

Includes([user list 2],ToUser(Part($list1,2,";"))) or

Includes([user list 2],ToUser(Part($list1,3,";"))) or

Includes([user list 2],ToUser(Part($list1,4,";"))) or

....

repeat until you hit what you imagine is the practical end of the number of users you might expect.

------------------------------
Chayce Duncan
------------------------------

QuintenCrum

Qrew Trainee

8 months ago

Thanks Chayce! Saved my brain this morning!

Forum Discussion

Matching part of a user-list to another user list