I want to bring in data from a separate sheet and filter it.
I can get IMPORTRANGE to work like this:
=IMPORTRANGE("URL","A:J)
But that doesn't filter. I can only get FILTER to work in the same sheet like this:
=FILTER(Sheet1!A:J, C:C="Yes")
Is there anyway to bring these two functions together and FILTER data from another spreadsheet into a new sheet, based on column C info?
The reason for doing this is to then use the auto notification setting, so whenever someone enters "yes" into the sheet I can be notified.
=IMPORTRANGE("URL","A:J")
? (You seem to be missing a quote.)