title: How to automatically fill a default value in a sheet cell
body: <p>I have a Google Form feeding a Google Sheet. Every time a user enters data via the form, a new row is created in the sheet. So far no problem.</p>
  
  <p>I need to assign to each leftmost cell the value <code>'true'</code> upon creation. Is there a way to do it in Sheets without the need for Apps Script? I've tried </p>
  
  <pre><code>sheet.getRange(1, 1).setValue('true')
  </code></pre>
  
  <p>but nothing happened.</p>
  
  <p>Any help is kindly appreciated. Thanks in advance.</p>