Using Formulas with Google Form Responses | Google Gooru | Information and digital literacy in education via the digital path | Scoop.it

Google Forms are one of the easiest ways to collect data from your friends, family, colleagues and more. A great way to make Forms even more powerful is by taking actions upon the responses in a Google Spreadsheet.

A lot of people get frustrated when they insert a formula into the responses Sheet, because the function doesn’t seem to carry over for every new entry. It can be very time consuming, and frankly pretty irritating to manually extend the function for every new response.