I have all data in one sheet and I need to filter the imported data to another sheet. How can I do that in one function?

Function to filter data which I use:


so how to combine this filter function with importrange function?

=IMPORTRANGE("URL", "Template!A16:C")
  • can you share a copy of your sheet?
    – user0
    Jun 28, 2019 at 14:06

1 Answer 1

  • in one go it would be like this:

    =FILTER(IMPORTRANGE("ID", "Template!A16:C"), 
     RIGHT(IMPORTRANGE("ID", "Template!A16:A"), 7)="?id=999")

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