SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 '12 at 11:50

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.

share|improve this answer
+1 for creative problem solving. – DrivenDevelopment May 3 '12 at 18:06

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.

share|improve this answer

It’s hard to filter by multiple conditions in a SharePoint list.

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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