Return to Answer

added 51 characters in body

Source Link

edited Dec 9, 2017 at 2:57

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

You can actually just put

=INDIRECT("Form Responses!A4")

=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.

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.

I tried Pnuts' solution 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.

Source Link

created Dec 8, 2017 at 22:40

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.