Combine "AND and "OR" with filtering

Options
philippejj0421
philippejj0421 ✭✭
edited 12/09/19 in Smartsheet Basics

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)?

Thanks!

Β«1

Comments