List of email addresses

[Jules_Lane]

Hi - just being a bit lazy but here’s an easy one

What is the correct expression syntax for this, which gives an error;

USEREMAIL()=MEMBERS.MYNYDD@GMAIL.COM OR
USEREMAIL()=MEETS.MYNYDD@GMAIL.COM OR
USEREMAIL()=CHAIR.MYNYDD@GMAIL.COM

I am trying to only show a data field if the users email is one of a list of 3.

[GreenFlux · Accepted solution]

Try:
IN( USEREMAIL(), {"MEMBERS.MYNYDD@GMAIL.COM", "MEETS.MYNYDD@GMAIL.COM", "CHAIR.MYNYDD@GMAIL.COM"} )

[TyAlevizos]

the IN() function helps, as well as noting that a list can be constructed with curly brackets. So this works:

IN(useremail(), {"MEMBERS.MYNYDD@GMAIL.COM", "MEETS.MYNYDD@GMAIL.COM", "CHAIR.MYNYDD@GMAIL.COM"} )

[Lucinda_Mason]

Good point. It took me several failed attempts to remember the curly brackets.

[Jules_Lane]

Perfect ! Thankyou.

[Steve]

Also, you’re using OR() wrong:

help.appsheet.com

OR()

Are any true?