title: Setting a Value to 40 cells while waiting 3 seconds between each set
body: <p>I'd like to set the values of D2 - D42 to FALSE, but I need to have about 3 seconds in between each update. So D3, wait for 3 seconds, D4, etc. I have other scripts that are tied to having a value of FALSE that take some time to run, which is why I need the sleep to happen. Here is what I have so far:</p>
  
  <pre><code>function rebuild() {
  SpreadsheetApp.getActiveSheet().getRange('D2:D42').setValue("FALSE");
  Utilities.sleep(4000);
  SpreadsheetApp.flush();
  }
  </code></pre>
  
  <p>This doesn't exactly work like I thought it would. It just waits for 3 seconds then populates all the values at the same time.</p>