Microsoft lists view - filter statements

Question

Hi all,

I am trying to create MS Lists custom view without success.

I am creating simple list to handle tickets. The important parameters for view are task status (new / in progress / completed), person the task is assigned to (there can be multiple people) and responsible person (task supervisor).

I am trying to create custom view to show tasks which are new or in progress for current user (both as assigned to or responsible). I created simple filter statement (included in screenshot) however this is also showing tasks where user is responsible and task is completed. What am I doing wrong? Is there any way to include parentheses in this statement?

In pseudocode I want to to create statement like: (status=="new" || status=="In progress") && (responsible == Me || Assigned_to == Me), but result of statement in screenshot is like this: ((status=="new" || status=="In progress") && Assigned_to == Me) || (responsible == Me)

Thanks for any help.

Answer 1

Dear Mike,

You can try the following steps:

1. Create a view with the following filter:

2. In this new view, open the filters pane, and check the New and In progress boxes under the Task Status section:

3. Then Save view as a new view.

I tested it on my side with the above steps, it meets your requirement on my side.

Original:

After:

Sincerely,

Jazlyn | Microsoft Community Moderator

Answer 2

Hello Jazlyn,

thanks for your suggestion however the problem is very similar now - with this filter I can see the tasks which status is in progress and are assigned to another person. In pseudocode ((Assigned_to == Me || responsible == Me) && status=="new" ) || (status=="In progress").

Best regard,

Mike

Answer 3

Dear Michal,

You can try the following filters to see the result:

Sincerely,

Jazlyn | Microsoft Community Moderator

Answer 4

Hello Jazlyn,

thanks for your reply. This might work however there are more task statuses (e.g. cancelled, interrupted, ...) which I forgot to mention. I would be glad if I find more universal solution (e.g. how to rewrite conditions that can be written in code).

Thank you again for your time.

Best regards,

Mike

Answer 5

Dear Mike,

Good day! Thank you for posting your query in our community.

Based on your description, you want to create a filter view for a MS List. I tested it on my side, you can try the following filter options:

My test list:

My result:

 

Sincerely,

Jazlyn | Microsoft Community Moderator