I have created a Google Form with an attached spreadsheet. Within that spreadsheet I have created several sheets to sort the answers to my liking.Sheet 2 is just an exact copy of all the original answer cells in Sheet 1, but with some columns added for further explanation. It works fine for a bit, but twice now the sheet has changed cell references on me vertically. It references fine from A2-A30, but then makes a jump which makes the next reference in Sheet2 cell A31 become Sheet1!A45. This goes for all columns horizontally, all the way up to column HY, which is my last.Any ideas?
Google Spreadsheet changing cell references on its own
google spreadsheets;google forms