SPLIT/LIST

AppSheet AppSheet Q&A
1

HI,

I have a VC column and I’m trying to create a slice where only rows with certain values that exist in an enumlist in another table are shown.

Only rows that match the first value of the enumlist are showing though. I’ve tried splittign the enumlist below but can;t get it to work

IN( [District User 3], SPLIT(LOOKUP(USEREMAIL(), “User Assign Alpha”, “User ID”, “First Call List To Combine”), ", "))

Thanks

Phil

2

Try with a SPLIT(**TEXT(**LOOKUP( , and split on the string " , " (space,comma,space)

2 Likes