Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Row Filter Conditions for multiple drop down values

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:

  • it either nothing happens at all because one of the columns satisfies the condition,  but the filter still allows columns with the other options to show
  • the filter shows no rows at in the view because it checks all columns for the same values instead

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:

# Col1Col2Col3
1NameA  
2Name  Delete
3Name CC
4NameDelete  

Filtered View:

# Col1Col2Col3
2Name  Delete
4NameDelete  
Solved Solved
0 6 556
1 ACCEPTED 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.

#NamesCol1Col2Col31
1NameABC
2NameAC 
3NameB  

 

Can you please try

AND(

OR(ISBLANK([Col1]), [Col1]="Delete") ,

OR(ISBLANK([Col2]), [Col2]="Delete") ,

OR(ISBLANK([Col3]), [Col3]="Delete")

)

 

 

 

View solution in original post

6 REPLIES 6
Top Labels in this Space