Form Response Sheet

Already Rock’n Google Forms? Now Master the Form Response Sheet!

Saturday October 24, 2015 12:45pm - 1:45pm - A205 (Administration Building A)

Add-ons and sheet formulas take the Form Response Sheet to the next level! Automated email responses, mail merges & auto-populating data tables that sort responses, count unique responses, and more...Click Here to view on Sched

Click Here to rock a demo form

Click here to view the Data

1) Navigating the Response Sheet

Click Here and make a copy of our sheet, then click below for some slick tips and tricks.

  • Freeze rows and columns
  • Wrap Text
  • Hide Columns, Hide Tabs
  • Color Code Rows & Columns
  • Rearrange Columns
  • Merge Data: =A1&": "&A2
  • Manually Drop Down a Formula

2) Building a Data Table

Once your form is collecting data, view ask the sheet to auto-tabulate how many times certain answers appear in the sheet.

Create data tables that auto-populate using formulas such as =COUNTIF


=COUNTIF(Select a column to search, what am I searching for)

  • Once you start the formula, and open the parenthesis, you can then just click on the column and/or cell to fill in the formula.

3) Auto-Generating Emails with Form Mule

  • Auto-generate feedback - FormMule Add-on

4) Merge Data Copy it Down Automatically

Click Here to read about the Copy-Down Add-on.

Sometimes you need a formula to copy down every time a participant submits a form. The Copy-Down Add-on is easy to use and very helpful.

Please take a moment to Evaluate this session - Click Here



CapCue Board Member

CUE Lead Learner

Google Certified Teacher

Google Certified Educator

CUE Rockstar Faculty