Hey so I am making these forms for a client, I created a form that links to a spreadsheet to collect responses, I then created a second spreadsheet to calculate the responses. I copy and pasted the formulas from lets say row 1 into row 2 to gather data from spreadsheet 1 but when new data is entered into the spreadsheet, the calculation sheet skips to the next line saying the formulas will record responses in row 3 instead of row 2,
Any help on this would be greatly appreciated
Here is a link to the spreadsheet for a better look:https://docs.google.com/spreadsheet/...Hc&usp=sharing
the sheets I am talking about are "Form Responses" and "Form Calculation"
Bookmarks