Skip to main content
1 of 2

I tried Pnuts above formula and it worked fine. I had tried the =Arrayformula but that did not work.

You can actually just put

=INDIRECT("Form Responses!A4")

Then when something posts it does not shove the rest of them down on the sheet you are importing data too.