title: Using IMPORTRANGE within a FILTER
body: <p>I found this question asked in other places, but I can't seem to get my formula correct...</p>
  
  <pre><code>=FILTER(ShortInventory!N:N , ROW(ShortInventory!N:N) =MAX( FILTER( 
  ROW(ShortInventory!N:N) , NOT(ISBLANK(ShortInventory!N:N)))))
  </code></pre>
  
  <p>This works, pulling data from a secondary tab on the existing spreadsheet. I would like to pull this directly from the external spreadsheet.</p>
  
  <pre><code>=FILTER(IMPORTRANGE("SOURCE","Responses!N:N") , 
  ROW(IMPORTRANGE("SOURCE","Responses!N:N")) =MAX( FILTER( 
  ROW(IMPORTRANGE("SOURCE","Responses!N:N") , 
  NOT(ISBLANK(IMPORTRANGE("SOURCE","Responses!N:N")))))))
  </code></pre>
  
  <p>I've tried variations of this and get the <code>#N/A</code> </p>
  
  <blockquote>
    <p><code>FILTER</code> has mismatched range sizes. Expected row count: 122. column count: 1. Actual row count: 1, column count: 1.</p>
  </blockquote>
  
  <p>I have no idea how to make this work.</p>