title: Google sheets Filter formula for text containing
body: <p>I am unable to make the below filter formula work. Notice that I am trying to refer to the sheet "Data" and filter them into another sheet. I get error saying there were no matches.</p>
  
  <pre><code>=FILTER(Data!A3:Data!J, ARRAYFORMULA(REGEXMATCH(Data!J3:Data!J, ".*km.*")))
  </code></pre>
  
  <p>However, the above formula works when I insert it in the "Data" sheet. Notice that "Data!" is removed as it is in same sheet.</p>
  
  <pre><code>=FILTER(A3:J, ARRAYFORMULA(REGEXMATCH(J3:J, ".*km.*")))
  </code></pre>
  
  <p>I tried using the below sets with same results.</p>
  
  <pre><code>=FILTER(A3:J, REGEXMATCH(J3:J, ".*km.*"))
  =FILTER(Data!A3:Data!J, REGEXMATCH(Data!J3:Data!J, ".*km.*"))
  </code></pre>
  
  <p>I have no problems filtering dates, numbers from "Data" sheet into my filtering sheet. It is only with "text contains" condition. Any help to resolve this is appreciated.</p>