I have a USER table that has multiple users and multiple roles.
if a user has more than one role, it only finds the first one.
- user1 Admin
- user1 Corphr
- user2 Corphr
IN(LOOKUP(USEREMAIL(), Users, Email, Role), LIST(“CorpHR”))
In the above senerio…user1 would not pass the formula selection, but user2 would.
even though they both are Corphr.
Should I be using a contains? or something else?