title: Set column default value in Google Sheets
body: <p>I have a finance tracking worksheet that has a number of formulas for each row. What I'd like to add is have these formulas replicate whenever a new row is inserted (fill it with a "default value").</p>
  
  <p>Sheet before adding the row:</p>
  
  <p><a href="https://i.stack.imgur.com/xUFED.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xUFED.png" alt="Before Adding Row"></a></p>
  
  <p>Sheet after adding the row:</p>
  
  <p><a href="https://i.stack.imgur.com/5tQZW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5tQZW.png" alt="After adding row"></a></p>
  
  <p>I'd like some of these cells (B28 in this case) to contain a formula. for this row the formula is: </p>
  
  <pre><code>=IF(ISBLANK(C27), "", CONCATENATE(YEAR(C27), "-", MONTH(C27)))
  </code></pre>