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! Go to Solution.
Try using an IN() formula instead of CONTAINS():
=IN([Approval],{“Yes”, “No”, “Improve”})
Try using an IN() formula instead of CONTAINS():
=IN([Approval],{“Yes”, “No”, “Improve”})
Works like magic! Thank you!
For reference:
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |