Google Spreadsheets / Forms tip

I love the form feature, but it’s still very simple and can be difficult to work with. But I did find a good trick to updating a sheet with a form attached (which is surprisingly not a standard feature):

To edit a form and columns so that they continue to match-up:
First make a backup if you are not sure about the following:
1. Make receiving sheet the left-most sheet (according to ahab above)
2. Open the form in the form editor
3. Make changes to the form and do not save or close yet.
4. On the receiving SS do Form > Delete
5. In form editor do Save: The SS columns will change to reflect the new form questions.
6. Test the form
7. Move the earlier data on the SS left to match the appropriate columns

Advertisements

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