Can't filer out blank rows in a slice

Val
Participant II

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?

Solved Solved
0 3 313
1 ACCEPTED SOLUTION

Jonathon
Participant V

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

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

View solution in original post

3 REPLIES 3

Jonathon
Participant V

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

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

Val
Participant II

Works like magic! Thank you!

Steve
Participant V

For reference:


Top Labels in this Space