Does anyone know how to filter respondent feedback into different sheets on the spreadsheet?

For example, each sheet collects information for separate classes and I want the form information to be sent straight to each particular class when that class is picked.


It is not possible. The Forms response sheet is the interface between completion of the form and access to the data in it. The conventional solution is to copy data from it to individual sheets as required.


Google Forms does not include that feature there several ways to achieve the desired result like using formulas with FILTER or QUERY functions to get the responses to the corresponding sheet or by writing a script with Google Apps Script.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.