title: Google Sheet script reset drop down boxes
body: <p>I have a spreadsheet with a tab for each day of the week.  On each tab there are several dropdown boxes that I would like to reset at the beginning of the week to either "Select" or "0".  The cells effected are the exact same on each tab.  I have identified the cells that need to be reset to "Select" and the cells that need to be reset to "0".  Is this possible?  I don't want to clear the sheet because it will clear the drop down lists.</p>
  
  <p>Below is what I have done already, but it won't save:</p>
  
  <pre><code>var sheet = SpreadsheetApp.getActive().getSheetByName('Wednesday').getSheetByName('Thursday').getSheetByName('Friday').getSheetByName('Saturday').getSheetByName('Monday').getSheetByName('Tuesday');
  var resetselectrange ('B23', 'C4', 'G4', 'K4', 'O4', 'S4', 'A7:A16', 'E7:E16', 'I7:I16', 'M7:M16', 'Q7:Q16', 'A19:A23', 'E19:E23', 'I19:I23', 'M19:M23', 'Q19:Q23', 'A26:A29', 'E26:E29', 'I26:I29', 'M26:M29', 'Q26:Q29', 'A38:A41', 'E38:E41', 'I38:I41', 'M38:M41', 'Q38:Q41');
  var resetzerorange ('C7:C16', 'G7:G16', 'K7:K16', 'O7:O16', 'S7:S16', 'C19:C23', 'G19:G23', 'K19:K23', 'O19:O23', 'S19:S23', 'C26:C29', 'G26:G29', 'K26:K29', 'O26:O29', 'S26:S29', 'C38:C41', 'G38:G41', 'K38:K41', 'O38:O41', 'S38:S41');
  var clearrange ('F2', 'A32', 'E32', 'I32', 'M32', 'Q32');
  </code></pre>
  
  <p>I'm obviously not an expert at this, and apparently my logic is not the correct logic.</p>
  
  <pre><code>var sheet = SpreadsheetApp.getActive().getSheetByName('Wednesday').getSheetByName('Thursday').getSheetByName('Friday').getSheetByName('Saturday').getSheetByName('Monday').getSheetByName('Tuesday');
  var resetselectrange ('B23', 'C4', 'G4', 'K4', 'O4', 'S4', 'A7:A16', 'E7:E16', 'I7:I16', 'M7:M16', 'Q7:Q16', 'A19:A23', 'E19:E23', 'I19:I23', 'M19:M23', 'Q19:Q23', 'A26:A29', 'E26:E29', 'I26:I29', 'M26:M29', 'Q26:Q29', 'A38:A41', 'E38:E41', 'I38:I41', 'M38:M41', 'Q38:Q41');
  var resetzerorange ('C7:C16', 'G7:G16', 'K7:K16', 'O7:O16', 'S7:S16', 'C19:C23', 'G19:G23', 'K19:K23', 'O19:O23', 'S19:S23', 'C26:C29', 'G26:G29', 'K26:K29', 'O26:O29', 'S26:S29', 'C38:C41', 'G38:G41', 'K38:K41', 'O38:O41', 'S38:S41');
  var clearrange ('F2', 'A32', 'E32', 'I32', 'M32', 'Q32');
  </code></pre>
  
  <p>The identified cells will be changed to "Select", Zero, or will clear entirely.</p>