shorten switch list

AppSheet AppSheet Q&A
, , , ,
1

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

2

How about.. IF(IN(USEREMAIL(),Sellers[Email]+Coordinators[Email]),“ALL_CHANGES”,“READ_ONLY”)

1 Like
3

@AleksiAlkio Hello and sorry for being late

yes perfect, Thank you very much

4

You’re welcome!