Adding Filter formula is confusing

Suggestion Box Bugs
1

If I add two filters like the below picture, the first row(of which Status is Done) is not filtered by the first rule.

filter bug
filter bug1185×649 30.8 KB

I think it is because two rules are connected by AND without parenthesis like “Not(Status.Contains(“Done”)) AND (true) OR (true)”, which always becomes true.

So if I add parenthesis to the second rule, the first filter works.

It is confusing to use.

2

I’ve run into this too. If you copy your table table (select it, CMD+C, CMD+V) and then open the filter page again you’ll probably see the two filters combined into one. That will tell you what the filter is being transformed to under the hood

I do think the issue is that there aren’t implicit parentheses being put around the second filter formula