title: How do I get Google Sheet Cell References to Change When I Move Rows?
body: <p>I am use Google Sheets to create set lists for my band. </p>
  
  <p>Each song has columns for "start time," "song length," and "set progress" so we can see how we're doing time-wise during our shows.</p>
  
  <p><strong>My problem</strong>: When I drag songs rows up or down to reorder the set list, cell references do not change and I have to copy and paste cell references to get the "start time" and "set progress" to refelect the proper timing.</p>
  
  <p>How do I get the cell references to update when I change the row order? <a href="https://docs.google.com/spreadsheets/d/1L6dsePJNDN7dtorJ9VLohxEr05PAwZs96MFPcm7VnU8/edit?usp=sharing" rel="nofollow noreferrer">Here's my sample sheet</a></p>