How to apply 2 different conditions in the filter of list?

Question

I have two different conditions based on which I need to apply filter on the list data.

The conditions are based on the user role and status column.

I have applied the filter condition as : Createdby equals to [Me] or Manager equals [Me] and Status equals to "Resubmitted" or Status equals to "In Progress".

The condition never turns out to be true so I none of my forms are visible.

Please guide...

Thanks a lot.

Answer 1

To group conditions like this,(I'm going to assume (A or B) and (C or D)) you could use calculated columns in conjunction with you list view filter.

Create two columns like this:

1stLogic = OR(CreatedBy = A, Manager = B) 2ndLogic = OR(Status = C, Status = D)

List view filters: 1stLogic equals Yes AND 2ndLogic = Yes

I haven't tried using the current user as data, or the [Me] operator, so that may be a problem with this method.

Answer 2

The SharePoint UI does not allow you to group the ORs and ANDs when building the filter in the browser. Thus the order of operations is top down.

To group the operations in your filter you would need to customize the view in ShaerPoint Designer.

More specific instuctions can be found here.

Answer 3

It’s hard to filter by multiple conditions in a SharePoint list when the logic combination would need parenthesis to force the evaluation sequence.

You can try the third-part add-ons, such as BoostSolutions List Advanced Filter, Kwizcom List Filter Plus, and more.