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”;
- 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.
Any help would be much appreciated. Thanks!