I’m having a hard time with the filter syntax. My guess is what I need is simple but I don’t know the “language” enough to know what I’m doing wrong. I’m trying to reference a row for “unfilled orders”. Here’s the test doc (“Filter View Unfilled Orders” subpage):
The last row on the bottom (titled “Unfilled Orders”) has a formula problem. My formula is:
[Pending Orders and Requests].Filter([Ordered By].Contains(thisRow)And(Delivered=false))
Without the “And . . .” section the formula works just fine, but I’m clearly formatting it correctly (or just going about it the wrong way). I’m awfully confident this is something Coda can do.