I have a simple form that inputs entries into a Sheets. All I want to do is open a new sheet and import the data from the forms sheet so I can manipulate it in my own way. I have tried:
=index('SHEETNAME'!A4:A4)
=SHEETNAME!A4
these formulas work but as soon as I get another entry on my Forms sheet the formula will skip that cell number.
Example
I get a new form input on A4 and to get the value of the new form data on my new sheet I use the formula:
=Form Responses!A4
All it does is change the formula to:
=Form Responses!A5
and leaves a blank block.