Hide rows based on multiple other columns

AppSheet AppSheet Q&A
1

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)

2

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",
        )
    )
)
2 Likes
3

Thank you, trying this out now

1 Like
4

It worked perfectly, thanks again.

1 Like