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:
these formulas work but as soon as I get another entry on my Forms sheet the formula will skip that cell number.
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:
All it does is change the formula to:
and leaves a blank block.