Combine powerful spreadsheet functions with Google Forms: Self-grading quizzes using Scripts, individual walk-through reports using TRANSPOSE, multiple data sources combined with VLOOKUP, mail merge with Gmail, and much more!
Slides
Formulas for Forms: Easy and Powerful Functions in Google SpreadsFormulas for Forms: Easy ...nctions in Google Spreads
What's the geekiest thing you've done with a spreadsheet or with a Google Form?
Individual Walk-Through Reports
Reports using TRANSPOSE (Search the Function List for official Syntax and Description) Tip: Nest a FILTER in the TRANSPOSE function to create a template that a less-technical user can simply cut and paste into instead of writing their own formulas.
Combine Multiple Data Sources with VLOOKUP
Send Confirmation Email after Form Submission with the FormEmailer Script
More Spreadsheet Formulas (Select "Google" from the drop down for some amazing new formulas not in Excel!)
What's the geekiest thing you're going to do with spreadsheets or forms?
|
|
