Answer the question
In order to leave comments, you need to log in
How to copy google spreadsheet rows that meet a condition?
Good afternoon!
There is a table, the data to which comes from Google Forms (a survey of employees).
This is a general table with employees' answers for all projects.
There are several more sheets with project names in the file.
How can I copy rows containing the project name in the corresponding column from the general table (the first sheet of the file)? Copied on the sheet of this project.
that is, there was some kind of sorting by projects and copying lines into project sheets, respectively.
Thanks in advance
Answer the question
In order to leave comments, you need to log in
Use FILTER (range; condition1; [condition2; ...])
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question