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