d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Google Spreadsheet
Add Reply New Topic New Poll
Member
Posts: 30,168
Joined: Jun 10 2010
Gold: 1,157.00
Oct 22 2024 07:39pm
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.
Member
Posts: 30,168
Joined: Jun 10 2010
Gold: 1,157.00
Oct 22 2024 11:01pm
i ended up separating them, but i still need to combine data but they have different amount of rows
Member
Posts: 30,168
Joined: Jun 10 2010
Gold: 1,157.00
Oct 23 2024 02:22am
example of 2 data sets

Go Back To Programming & Development Topic List
Add Reply New Topic New Poll