I have 2 spreadsheets, want to only import certain columns and ONLY if a certain column is > 0
=FILTER(
{
IMPORTRANGE("...","Sheet1!A:A"),
IMPORTRANGE("...","Sheet1!E:E"),
IMPORTRANGE("...","Sheet1!L:L"),
IMPORTRANGE("...","Sheet1!F:F"),
IMPORTRANGE("...","Sheet1!I:I"),
IMPORTRANGE("...","Sheet1!C:C")
},
AND(Sheet4!B:B > 0, Sheet4!G:G > 0, COUNTA(IMPORTRANGE("...","Sheet4!B:B")) > 0)
)
Function ARRAY_ROW parameter 4 has mismatched row size. Expected: 560. Actual: 990.
name/date/amount, G and B is amount.