Google-sheets – Pulling data from one sheet to another if

formulasgoogle sheetsgoogle-sheets-query

My knowledge is pretty basic when it comes to excel and Google Sheets. I'll explain what I'm trying to do.

I'm trying to find a way to filter information from 1 sheet to another in Google Sheets. Ideally, I would like to display an entire row if it is a certain colour. If I can't do it by colour then I'd like to display the row if a certain column within the row says COMPLETE. I have many rows to sort through so I'd really like a way to do this automatically instead of copy and paste.

Any help is greatly appreciated!

Best Answer

also, you can have this:

=FILTER('Sheet1'!A1:Z; C1:C = "COMPLETE")

  • Sheet1 - a name of the sheet from which you want to import
  • A1:Z - the range you want to import
  • C1:C = "COMPLETE" - filter out only those occurrences which have a given word in column C
Related Topic