title: How to filter by multiple columns with OR strings...and nested OR within column?
body: <p>Using the 'Filter by condition' option, how can you create an 'OR' filter across multiple columns that contains multiple 'OR' strings within the column(s)?</p>
  <p><a href="https://stackoverflow.com/questions/47207299/how-do-i-filter-view-two-columns-or-instead-of-and">This answer</a> is great for an 'OR' filter for single strings in multiple columns:</p>
  <p><code>=OR(D:D=&quot;x&quot;,E:E=&quot;x&quot;)</code></p>
  <p>How can this formula be edited for nested OR query within the column?</p>
  <p>E.g. make column D filter on multiple options instead of only &quot;x&quot;, such as (&quot;x&quot; OR &quot;y&quot; OR &quot;z&quot;)?</p>