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.
IN(USEREMAIL(), LIST(“abc@email.com”, “def@email.com”))
@Bellave_Jayaram can you use this expression with just the domain part of the email?
@Simon_Adcock you can use CONTAINS instead of IN.
CONTAINS (LIST(“domain1”, “domain2”), USEREMAIL ())
Thanks guys. I tried using the IN (USEREMAIL(), LIST and it works.
How about CONTAINS(USEREMAIL(),“appsheet.com”) or IN(RIGHT(USEREMAIL(),(LEN(USEREMAIL())-FIND("@",USEREMAIL()))),{appsheet.com,gmail.com})
User | Count |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |