Bug in Microsoft Lists Edit View Filter Logic

%3CLINGO-SUB%20id%3D%22lingo-sub-2143882%22%20slang%3D%22en-US%22%3EBug%20in%20Microsoft%20Lists%20Edit%20View%20Filter%20Logic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143882%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20edit%20a%20view%20to%20display%20only%20time%20critical%20project%20items%20in%20a%20list%20to%20easily%20show%20task%20priorities.%26nbsp%3BThe%20issue%20I'm%20having%20is%20even%20when%20A%20and%20B%20filter%20conditions%20are%20true%20(conditions%20labeled%20in%20image%20below)%2C%20the%20corresponding%20list%20item%20doesn't%20appear%20in%20the%20view.%26nbsp%3B%20Written%20out%2C%20I'd%20expect%20the%20logic%20to%20be%20evaluated%20as%20such%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20A%20and%20B%20or%20C%20and%20D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mpool1450_0-1613585754899.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255576iE6F49A8E3EC873F8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mpool1450_0-1613585754899.png%22%20alt%3D%22mpool1450_0-1613585754899.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20C%20and%20D%20are%20true%20for%20a%20list%20item%2C%20it%20appears%20in%20the%20view%2C%20but%20as%20mentioned%2C%20that%20isn't%20the%20case%20when%20A%20and%20B%20are%20true.%20I%20created%20a%20separate%20view%20with%20only%20A%20and%20B%2C%20and%20the%20items%20matching%20A%20and%20B%20conditions%20did%20appear%20in%20that%20view.%20This%20looks%20like%20a%20bug%20to%20me%2C%20but%20I'd%20be%20happy%20for%20someone%20to%20tell%20me%20my%20reasoning%20is%20flawed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20also%20at%20a%20loss%20for%20a%20workaround.%20Played%20around%20with%20the%20filtering%20capabilities%20of%20lists%20for%20a%20while%20and%20found%20them%20to%20be%20somewhat%20limited.%20Using%20filters%20in%20a%20view%20is%20the%20only%20way%20I%20can%20find%20to%20show%20item%20statuses%20being%20evaluated%20against%20multiple%20relative%20timing%20conditions.%20Any%20ideas%20on%20a%20different%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2143882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I'm trying to edit a view to display only time critical project items in a list to easily show task priorities. The issue I'm having is even when A and B filter conditions are true (conditions labeled in image below), the corresponding list item doesn't appear in the view.  Written out, I'd expect the logic to be evaluated as such:

 

If A and B or C and D

 

mpool1450_0-1613585754899.png

 

If C and D are true for a list item, it appears in the view, but as mentioned, that isn't the case when A and B are true. I created a separate view with only A and B, and the items matching A and B conditions did appear in that view. This looks like a bug to me, but I'd be happy for someone to tell me my reasoning is flawed.

 

I'm also at a loss for a workaround. Played around with the filtering capabilities of lists for a while and found them to be somewhat limited. Using filters in a view is the only way I can find to show item statuses being evaluated against multiple relative timing conditions. Any ideas on a different way to do this?

0 Replies