I have a Google Form linked to a Google Sheet with two files. One file is the responses that are pushed from the form and the other sheet I am using to combine all of the answers into one cell to send an email to the user. I am using this formula to pull in the user email: ='Form Responses 1'!B2

The issue I am having is the form inserts a new cell with each response, so the response will go into the B2 cell but the formula will change to ='Form Responses 1'!B3 when this happens. How do I make B2 the absolute reference even if a new row is inserted?

1 Answer 1




=INDIRECT("Form Responses 1!B2")

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.