Hide rows based on multiple other columns

[hartable]

My table has 6 drop down Rank columns with 8 Options, one being "Delete". I need to figure out a rule that  If 1 of 2 specific priority  rank columns has "Delete" AND  any other rank columns have "Delete" the row get hidden.

Is there a possibility to do this?

(Note: the layout with the columns /dropdowns is a specific request so I can't change that part even though there are better ways to do it)

[WillowMobileSys · Accepted solution]

There is not a specific construct that hides rows - per say. 

Instead you want to apply filtering - i.e. SHOW all rows that DO NOT meet the criteria.

Generally for filtering in AppSheet, a YES/NO expression would be applied to each potential row to decide if it should be included or not.  The expression would be something similar to:

--remember this is to SHOW/INCLUDE rows - (opposite of your criteria) reason for NOT:--
NOT(
    AND(
        OR([Priority Rank Column 1] = "Delete",
           [Priority Rank Column 2] = "Delete"
        ),
        OR([Rank Column 3] = "Delete",
           [Rank Column 4] = "Delete",
           [Rank Column 5] = "Delete",
           [Rank Column 6] = "Delete",
        )
    )
)

[hartable]

Thank you, trying this out now

[hartable]

It worked perfectly, thanks again.