CODEWITHSUNDEEP
selectgoogle-sheetsgoogle-sheets-formula
Jana
Jana

Reputation: 11

Query including Importrange

I have one google spreadsheet, which is my source sheet. Now I have three more spreadsheets in which I want to pull information from the source sheet. To solve this I made use of the Query(Importrange) function. My problem is, that I only want to pull information, if a certain column in the source sheet is not blank. To do so, my function looks like this:

=Query(IMPORTRANGE("https://docs.google.com/spreadsheets/....","Sheet name!range"),"SELECT Col.. WHERE Col..!=''")

As selected columns I chose all columns that I want to copy from the source sheet into the new one. The column behind WHERE is the column that is not allowed to be blank.

NOW there is the following problem: Some information is imported from the source sheet into the new one the right way, but others are not imported at all. Maybe because in the source Sheet there are some columns with dates, some with numbers, some with words.

I would be very happy if somebody could help me! Thank you!

Upvotes: 1

Views: 108

Answers (1)

player0
player0

Reputation: 1

force it:

=ARRAYFORMULA(QUERY(TO_TEXT(IMPORTRANGE("url", "sheet name!range")),
 "select Col.. 
  where Col.. is not null", 0)

Upvotes: 1

Related Questions