Can't filer out blank rows in a slice

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?

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

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

3 Likes

Works like magic! Thank you! :heart_eyes:

1 Like

For reference:


2 Likes