I want to bring in data from a separate sheet and filter it.
I can get IMPORTRANGE to work like this:
But that doesn't filter. I can only get FILTER to work in the same sheet like this:
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.