There are three columns A, B, C AND today date is in the first row of the column A means A1. I need to import these three columns date excluding date row. A2:A100, B2:B100, C2:C100 in another sheet.

I have tried this:

=filter((importrange("sheets key", sheet1!A:F),
 importrange("sheets key"sheet2!A2:C10 =TODAY()))

My formula got an error cannot solve this.

sheet 1 data sheet 2 data -imported


2 Answers 2


FILTER require that the first argument is a valid range reference, so it's not valid to use IMPORTRANGE or another function as the first argument. There are several alternatives like using FILTER in the source spreadsheet the on the destination spreadsheet use IMPORTRANGE to import the range that holds the FILTER result.

Another alternative is to use QUERY instead of FILTER.

  • Please add a brief explanation of your answer. Why it answer the question? How it is relevant?
    – user0
    May 28, 2019 at 0:29
  • sample it out and then use IMPORTRANGE to extract it out

 ADDRESS(2,  MAX(IF(Sheet1!1:1=TODAY(), COLUMN(Sheet1!1:1), )), 4)&":"&
 ADDRESS(10, MAX(IF(Sheet1!1:1=TODAY(), COLUMN(Sheet1!1:1), ))+2, 4)))




Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.