How to search an Enum List?


Just started to use AppSheets and so far its really amazing what you can do.
I have an Enum List (seperated by “,”) and would like to be able to search my table to see if any of the values in a certain column have a specific word?
I can get it to find the specific word if it is the only item in the cell but when the cell has multiple items from the enum list, it fails to findit.

Please take a look at

1 Like

Thank you!
So Simple, sorry to waste the time.


We’re here to help!