2

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.

1
  • In addition you need to accurately describe the condition you're after. What you've written could be (A or B) and (C or D) or it could be A or (B and C) or D or lots of other combinations. You won't get anywhere without being very specific in your details.
    – Ryan
    May 3, 2012 at 11:50

3 Answers 3

6

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.

1
0

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.

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.