Filtering with Google Forms

Recently, I wanted to move/copy any data that had an 'X' in the completed column into an archived spreadsheet. And, luckily, I found the formula to do just that!

Unfortunately, I'm still working on how to have the data in the original sheet with an 'X' in the completed column hide or disappear once it has been copied to the new sheet.



The good news is that this formula has many benefits. For instance, if you want a district/school-wide form where respondents need to select a particular teacher, you can use this formula to separate that data into sheets and assign the associated teachers with permissions to that sheet only. This enables groups to use one form and to allocate information to a set of people or a specific individual.

Check out this formula! It's simple and can be applied to a variety of situations, spreadsheets, and forms.