Using IMPORTRANGE within a FILTER

Question

I found this question asked in other places, but I can't seem to get my formula correct...

=FILTER(ShortInventory!N:N , ROW(ShortInventory!N:N) =MAX( FILTER( 
ROW(ShortInventory!N:N) , NOT(ISBLANK(ShortInventory!N:N)))))

This works, pulling data from a secondary tab on the existing spreadsheet. I would like to pull this directly from the external spreadsheet.

=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")))))))

I've tried variations of this and get the #N/A

FILTER has mismatched range sizes. Expected row count: 122. column count: 1. Actual row count: 1, column count: 1.

I have no idea how to make this work.

I read about using QUERY with IMPORTRANGE in a FILTER, and modified my formula. It didn't work, but using this independently does reference the correct column. Searching for answers... =QUERY(IMPORTRANGE("Source","Responses!N:N"),"Select * where Col1 = '0'") — jarmerson
(Master with a tab pulling data from responses) docs.google.com/spreadsheets/d/… (Responses) docs.google.com/spreadsheets/d/… (Form) docs.google.com/forms/d/e/… — jarmerson

player0 player0 · Accepted Answer · 2019-03-22T21:50:08

=FILTER(IMPORTRANGE("1gyAaxDzklUuhwBdLpMkb2jgrPmbJ9WxtdJ1JOO2d424","Responses!N1:N101"),
 ROW(A1:A101)=MAX(FILTER( ROW(A1:A101),NOT(
 ISBLANK(IMPORTRANGE("1gyAaxDzklUuhwBdLpMkb2jgrPmbJ9WxtdJ1JOO2d424","Responses!N1:N101"))))))

Using IMPORTRANGE within a FILTER

1 Answers