1

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?

migrated from superuser.com Jan 28 '18 at 20:43

This question came from our site for computer enthusiasts and power users.

2

Use INDIRECT

Example

=INDIRECT("Form Responses 1!B2")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy