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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s