title: How to get the value of column D in the current row?
body: <p>If I have a simple spreadsheet such as this:</p>
  
  <pre><code>A  B      C   D
  1  Hello  30  60
  2  World  45  90
  ...
  </code></pre>
  
  <p>…where I want column D to simply be column C*2, how could I do that? Obviously, I could manually set the contents of each row's D column to be <code>=C1 *2</code>, <code>=C2 *2</code>, and so on, but if I have hundreds of rows, it'd be easier to have something along the lines of <code>=C$ROW *2</code> — is that possible?</p>