I want to apply a filter to a table, but I’m missing the right formula. Can anyone help?
What I want:
I only want to see items of a table where itemX = checked. In addition, I only want to see items that contain Y OR Z. So basically, itemX= checked always has to be true and from that selection I want coda to only show me the rows that contain either Y or Z.
It returns true if the value in the field Items contains either Y or Z
And for the filter to returns one or more rows, both conditions needs to be true (as I used AND)
Here’s a sample to illustrate .
The filter formula has been applied on the [View of Table] so you’ll be able to see the differences between the unfiltered source table called Table (where the results of the filter are highlighted through conditional formatting) and the actual filtered view.