Combine "AND and "OR" with filtering
I did not see this topic covered:
Is there a way to combine logical "AND" and "OR" when creating a filter?
The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR)
Here is why I am asking:
I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions" field. But I want to also add a strict time window.
To put it another way, I want a filter that can do:
"Date greater than X" AND "Date Less than Y" AND ["Buzzword in Field A" OR "Buzzword in Field B"]
Or, is it possible to "Pipe" filters: Results of "Filter A" (set time frame) are piped into "Filter B" (look for buzzword)?