Sharepoint View Filter: Filter in blank date + Assigned To = specified + Status = specific

Question

Hello, 

I'm not able to get my view to filter the way I need it to. I can successfully 

I need: 

- Close Out Date = Blank 

AND

- Assigned To = Specific Person

AND

- Status not equal to Complete (or) Cancelled

I'm able to filter the queue for the specific assigned to person & specific status, but when I add the 3rd dimension of Close Out Date = blank, I'm not able to get the view to filter properly. When I apply the above filter, I test the item by changing only the status to Complete BUT leave Close Out Date blank, and the view still filters out the item. I want the view to keep that item filtered in until BOTH the Close Out Date does not = Blank (AND) Status equals Complete or Cancelled

Answer 1

Hi Cash,

Thanks for providing the detailed information for us which made my test more convenient.

I tested at my end by using the Filter feature in Edit View setting, but I have the same result as yours. (The items were not filtered in the result.) Then I found that we can use the Filter by feature of the column as a workaround.

Since we can reproduce this issue at my end, we assume this issue is more complicated than we thought. And we are unable to investigate this issue at my end due to the limited resources. I sincerely suggest you contact IT admin to raise a ticket in Office 365 admin center, and I will provide a summary of this issue in PM link for you. It will benefit the agent to speed up the process. Your understanding is highly appreciated.

For more information, please refer to: Get support

Best Regards,

Ivy