0

I'm creating a SP list view and trying to apply a filter to it without creating calculating columns to compare:

Show items only when the following is true:

  • Status equals to "Cancelled" AND Cancelled Date is greater than or equal to [TODAY]-180 AND Region equals to "1"; OR
  • Status equals to "Rejected" AND Rejected Date is greater than or equal to [TODAY]-180 AND Region equals to "1"

Below is what I've tried. Most likely it's the order of the AND/ORs but I can't seem to figure it out.

This is what I've tried.

Any help would be much appreciated. Thanks!

Improve this question

1 Answer 1

Reset to default
1

you need to merge them up so that you select items that you need in view. You can make this as

(Status equals to "Cancelled" OR Status equals to "Rejected" ) AND (Cancelled Date >= [TODAY]-180 OR Rejected Date >= [TODAY]-180) AND (Region equals to "1")

That should give you correct items.

Improve this answer
1
  • Thank you so much! You have saved me a bottle of Tylenol for the headache! Commented Aug 26, 2020 at 14:33

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.