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:
=FILTER(A7:C,RIGHT(A7:A,7)="?id=999")
so how to combine this filter function with importrange function?
=IMPORTRANGE("URL", "Template!A16:C")