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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |