How to apply formulas to form data in Google Spreadsheets
We have a Google Spreadsheet that multiple people can enter data into. For each entry we have created a series of formulas to run calculations and derive totals from the values entered. We decided to make it simpler to enter data by using a form. This works amazingly, as you can control what data can [...]

