Can't filer out blank rows in a slice

[Val]

I need to have a slice with rows with particular values in Approval column:

Row filter condition
=CONTAINS({“Yes”, “No”, “Improve”},[Approval])

It generally works, but for some reasons blank values are also included in a view of that slice. I also ran a test for the rule - test shown “N” in front of rows with blank Approval column.

I also tried CONTAINS({“Yes”, “No”, “Improve”},[Approval]) AND ISNOTBLANK([Approval]) but it doesn’t help.

What to do?

[Jonathon · Accepted solution]

Try using an IN() formula instead of CONTAINS():

=IN([Approval],{“Yes”, “No”, “Improve”})

[Val]

Works like magic! Thank you!

[Steve]

For reference:

help.appsheet.com

CONTAINS()

Does text contain fragment?

help.appsheet.com

IN()

Is item in list?