June Tip for Google Forms

Google forms are great for getting feedback and information.  They are easy to set up and link to a web page.  One complaint I always hear is that once they set up their form and tweak it, the spreadsheet of responses doesn't look right.  When they look at their spreadsheet, the column headings don't line up with the order of their form questions.  Here is a simple trick that will make sure that those always line up.

Step One - Create your form

Step Two - Edit the form - tweak - adjust - move items - copy items - etc.

Step Three - Test the form and make sure you are getting the information you want

Step Five - Click on view responses - If you have made alot of changes as you were creating your form, chances are good that the column headings don't line up with the order of your form questions

SUPER SIMPLE FIX

• Go back to your form
• Click on Responses on the menu bar at the top
• Click on Change response destination

Now, when you click on view responses, the column headings in your spreadsheet will line up in the order of your form questions.  Do this when you are confident that you are finished with your form.  THEN, you are ready to publish your form link and start accepting responses.  I hope this helps you out.  As always, it's not what you know, but what you SHARE!