Hi, is there a way to shorten the following switch list of sellers and coordinators?
I have tried but has not worked
SWITCH(USEREMAIL(),
INDEX(INTERSECT(list(useremail()),Sellers[Email]),1,),"ALL_CHANGES",
INDEX(INTERSECT(list(useremail()),coordinators[Email]),1,),"ALL_CHANGES",
"READ_ONLY")
Thanks
Solved! Go to Solution.
How about.. IF(IN(USEREMAIL(),Sellers[Email]+Coordinators[Email]),"ALL_CHANGES","READ_ONLY")
How about.. IF(IN(USEREMAIL(),Sellers[Email]+Coordinators[Email]),"ALL_CHANGES","READ_ONLY")
@AleksiAlkio Hello and sorry for being late
yes perfect, Thank you very much
You're welcome!
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |