title: Google Forms changes cell reference on different sheet in Google Sheets
body: <p>I'm building a spreadsheet to track my macronutrients and calories. I made a google form for inputting information and it populates a "responses" sheet on google sheets. I made a different sheet within the same spreadsheet to perform all the calculation and generate graphs.</p>
  
  <p>But every time I enter a new response into the form, it creates a new row and changes all the cell references in the calculations sheet. For example, I reference cell A2 from the responses </p>
  
  <pre><code>='Form Responses'!A2
  </code></pre>
  
  <p>and when I actually fill out the form and it populates, A2 in the responses sheet is filled in but the reference in my calculations sheet has been changed to A3. </p>
  
  <pre><code>='Form Responses'!A3
  </code></pre>
  
  <p>I tried using $ but it did the same thing, automatically changes the cell that I referenced.</p>
  
  <p>Any way to have my calcuations sheet reference the newly created rows automatically?</p>