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.
Best Answer
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.