How to have SWITCH with Multiple Expected Values for the Same Expect Result?

Dear Colleagues,

I would like to know how to have SWITCH with Multiple Expected Values for the Same Expect Result please?

I have the following expression from the Data Table Provile for “Are Updates Allowed?”:

Standard:
SWITCH(USEREMAIL(),
user1@mydomain.com”, “UPDATES_ONLY”,
user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)

I want to make it like this, where the Expected Resulit of “ALL_CHANGES” has multiple email addresses:

SWITCH(USEREMAIL(),
(OR “user1@mydomain.com”, “user2@mydomain.com”), “ALL_CHANGES”,
“READ_ONLY”)

The above does not work, so what is the correct expression to allow different email addresses to have “ALL_CHANGES”?

Thanks.

0 6 1,240
6 REPLIES 6
Top Labels in this Space