I have a library with a few folders in it, and the files in the folder have a "Status" property and an "Assigned To" field.
I want to make a view with the following logic:
If (Content Type == Folder) OR ((Status == "Blah") AND (Blah Status Assigned To == [Me]))
so that when I email a link to the pre-filtered library, the user can see the folders in the root of the library, but also only see the files he's assigned.
I've tried setting up the view's filters as "Assigned To" AND "Status" OR "Content Type", as well as the other way around to try and work with SP's order of operations, but neither seems to work.
Basically I want a View to show files of a given criteria, AND all folders. Is what I'm trying to do possible just using the basic filters?