Filter combination of ands/ors

I have an inline list that I would like to filter with a combination of ANDs/ORs. It looks like I can do one but not both. The use case is that I have a table that has a series of checkboxes, say Q1 and Q2, and my user has corresponding checkboxes. I want to display a given item in the table if:

((Q1 is true AND Q1response is true) OR (Q1 is False)) AND ((Q2 is true AND Q2response is true) OR (Q2 is False))

Can’t think of another way other than a combination of many If Then Else columns. Sounds pretty complex.

How would I create the columns? The Q1response column is based on user input.

See if this gives you some ideas:

1 Like