Expression Assistant - True False for cell with multiple, comma delimited values

[Bruno_Colorado]

Hello,

Thanks for any assistance! Will keep this brief. I have an Edit expression for a column:

OR(USEREMAIL()=[EMAIL_COLUMN_A], USEREMAIL()=[EMAIL_COLUMN_B])

If the user’s email matches the email in either column A or B, they can edit the record. So far so good.

Issue: I’d like to store more than 1 email addresses in EMAIL_COLUMN_B. However, if I try to add a 2nd email there (comma delimited), the 2nd email/user isn’t given edit rights.

Question: How do I modify this expression so that multiple records within 1 cell are parsed, instead of just the first.

I’ve tried to use IN LIST, but it only seems to allow text entries, not column references. Something like:

OR(USEREMAIL()=[EMAIL_COLUMN_A], IN(USEREMAIL()=LIST([EMAIL_COLUMN_B])))

No dice…

Regards,

-B