I'm trying to copy data from a Google Sheets tab linked to a Google form into a new tab. I used the function ='Form Responses 1'!B2, then copied the formula in the other cells of the column. But when I submit a new form, the formula in the destination cell automatically skips a row. So instead of the next row getting data from the next cell in the column from the responses tab, nothing moves over and the formula is changed to ='Form Responses 1'!B4 instead of the formula ='Form Responses 1'!B3, which it was prior to me submitting the form.

What am I doing wrong?

  • How about =FILTER('Form Responses 1'!B2:B,LEN('Form Responses 1'!B2:B)>0) which will give you all the values in 'Form Responses 1'!B2:B' that aren't BLANK
    – Blindspots
    Jun 1 at 20:41
  • Does this answer your question? Separating responses to different Sheets in Google Sheets Jun 2 at 10:44
  • That worked. Thanks so much.
    – Jeff
    Jun 2 at 17:16
  • @Rohit It's important that you check out the Community Bulletin and Meta Stack Exchange as soon as possible if you haven't already. It's crucial that you participate in the ongoing election for the Web Applications community moderator. For more information on how to do so, please visit 2023 Community Moderator Election.
    – Rubén
    Jun 7 at 23:06


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.