Filter combination of ands/ors

[Misty_Meadows]

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))

[ThinhDinh]

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

[Misty_Meadows]

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

[Jeff_Hager]

See if this gives you some ideas:

Logical Math Column

No, you currently cannot mix AND’s and OR’s in conditions, but there are a few options: Put all of the logic in your sheet using however many columns are necessary, or reverse your thought a little bit and set up an IF/THEN column like this: IF C=0 THEN ‘true’ ELSE IF A<>1 THEN ‘false’ ELSE IF B<>1 THEN ‘false’ ELSE ‘true’ Put all of the AND logic in the sheet and only use OR’s withing the filter conditions. Not always, but sometimes you can reverse your thinking like the first example and…