I am trying to create a view via my Slices Row Filter conditions that only shows rows with Blanks or the Dropdown option "Delete" in 5 different columns.
Each row has a drop-down list of 6 options, but I need one view that only shows rows that at least one of the specified columns is a Blank or has selected Delete, and not show any rows that have any of the other drop down options.
I've tried different ways of attacking this in different ways, but I think I'm caught in the logic here, when ever I try to make a formula for this:
How would I can, I create a filter that will show only rows where these any of these columns have either of these two values in at a least one of them. But also not show rows with any other values in those specific columns
Now:
# | Col1 | Col2 | Col3 | |
1 | Name | A | ||
2 | Name | Delete | ||
3 | Name | C | C | |
4 | Name | Delete |
Filtered View:
# | Col1 | Col2 | Col3 | |
2 | Name | Delete | ||
4 | Name | Delete |
Solved! Go to Solution.
Thanks for more info. Yes, earlier expression was suggested on incomplete data. I think there are still more possibilities that you have not listed. For example if columns are just A, B or C with or without spaces and without "Delete" in any of them.
For example ,expected results for below cases are not mentioned.
# | Names | Col1 | Col2 | Col31 |
1 | Name | A | B | C |
2 | Name | A | C | |
3 | Name | B |
Can you please try
AND(
OR(ISBLANK([Col1]), [Col1]="Delete") ,
OR(ISBLANK([Col2]), [Col2]="Delete") ,
OR(ISBLANK([Col3]), [Col3]="Delete")
)
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |