FSA Tip #26 Working With Google Form Answers

This is the second in a series of Farm Spreadsheet Tips about Google Forms.

Last tip we set up a Google Form to gather harvest data during your harvest mornings. In this tip, we’ll link that form to one of your farm spreadsheets so you can work with the answers.

This works for all Google Forms. Not just. harvest logs!

In this tip, we’ll see …

  • How to enter date in a Google Form
  • How to link your google form to a farm spreadsheet
  • How your linked spreadsheet updates immediately
  • How to set up a report to look at your form answers using SORT/UNIQUE and SUMIF

You can get the spreadsheet from this tip to follow along at home.

What will you do when you merge your Google Forms with your Farm Spreadsheets?

Leave a Reply