I'm trying to restrict a certain tables to on...

[WAN_AHMAD_SHAIL]

I’m trying to restrict a certain tables to only two users. Is this expression correct : USEREMAIL()= abc@email.com, def@email.com correct?

Please advice.

[Bellave_Jayaram]

IN(USEREMAIL(), LIST(“abc@email.com”, “def@email.com”))

[Simon_Adcock]

@Bellave_Jayaram can you use this expression with just the domain part of the email?

[Bellave_Jayaram]

@Simon_Adcock you can use CONTAINS instead of IN.

CONTAINS (LIST(“domain1”, “domain2”), USEREMAIL ())

[WAN_AHMAD_SHAIL]

Thanks guys. I tried using the IN (USEREMAIL(), LIST and it works.

[Aleksi_Alkio]

How about CONTAINS(USEREMAIL(),“appsheet.com”) or IN(RIGHT(USEREMAIL(),(LEN(USEREMAIL())-FIND("@",USEREMAIL()))),{appsheet.com,gmail.com})