Filtering logic (grouping)

1

A quick question: how to set filtering logic in FILTER DATA with both operators as follows:

(A or B) and C

It seems that there is a possibility to pick only AND or OR, but never both.

2

IF logic in Glide is gross.

You are better off moving that logic into your table with an IF column, and then flip your logic around to make it work with Glide’s limitation.

Something like this:

IF <> C Then false
ELSEIF = A Then true
ELSEIF = B Then true
ELSE false

Then change your filter to use that IF column instead and only check for True (checked).

1 Like