Dynamically filter a comma separated text.

AppSheet AppSheet Q&A
1

Hi there,

I want to filter a comma-separated text dynamically with the values I enter in a ENUMLIST type column. I write this expression but I get NO or FALSE to all even though I’m sure that the value/values I put in ENUMLIST type column are present in the comma-separated text.

IN(
ANY(
SELECT(
filter[1_criteria],
TRUE
)
),
SPLIT([concatenatedLabels], ", ")
)

with this expression, I get all FALSE. Can you help me please?

1111.png
1111.png1055×815 33.6 KB

1 Like
2

At least the SPLIT() is used in a wrong way as you have specified the delimiter as comma-space. But in your Enumlist column, the separator is just a comma. So.. remove the space away from the SPLIT() and see if that helps.