title: Multiple OnEdit Google Scripts in same sheet - Separately they work, together not so well
body: <p>I have these scripts working separately but when I combine them or create two different scripts only one will function. If found that the conditional formatting tool was bogging down my spreadsheet, so I used the first script to replace that function and it made all the difference. The second script is simply an archive script to move the row to an archive sheet. Only one will function at a time, no matter who I combine them. I've tried two separate scripts and I tried combining. Including changing the name of the function so. What am I missing?</p>
  
  <pre><code>function onEdit(e) {
  if (e) { 
      var ss = e.source.getActiveSheet();
      var r = e.source.getActiveRange(); 
  
          // E.g. status column is 2nd (B)
          status = ss.getRange(r.getRow(), 2).getValue();
  
          // Specify the range with which You want to highlight
          // with some reading of API you can easily modify the range selection properties
          // (e.g. to automatically select all columns)
          rowRange = ss.getRange(r.getRow(),3,1,8);
  
          // This changes font color
          if (status == 'Complete') {
              rowRange.setFontColor("#d3d3d3");
              rowRange.setBackgroundColor("#FFFFFF");
          } else if (status == 'This Week') {
              rowRange.setFontColor("#000000");
              rowRange.setBackgroundColor("#ACE5A2");
          } else if (status == 'Next Week') { 
              rowRange.setFontColor("#000000");
              rowRange.setBackgroundColor("#D3D8D9");
          } else if (status == 'Priority') { 
              rowRange.setFontColor("#FFFF11");
              rowRange.setBackgroundColor("#1997F6");
          } else if (status == 'Late') { 
              rowRange.setFontColor("#D92B14");
              rowRange.setBackgroundColor("#FFFFFF");
          } else if (status == '') { 
              rowRange.setFontColor("#000000");
              rowRange.setBackgroundColor("#FFFFFF");
          }   
      }
  }
  </code></pre>
  
  <hr>
  
  <pre><code>function onEditArchive() {
  
  var sheetsToWatch= ["Valley","DBWC","Genus Heart","Mutli 
  Run","ECM","MRE","Medella","Mitro"];
  
  
  var columnNumberToWatch = 10; // column A = 1, B = 2, etc.
  var valueToWatch = "Archive";
  var sheetNameToMoveTheRowTo = "Archive";
  
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();
  
  
  if (sheetsToWatch &amp;&amp; range.getColumn() == columnNumberToWatch &amp;&amp; 
  range.getValue() == valueToWatch) {
  
  var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
  var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 
  1);
      sheet.getRange(range.getRow(), 1, 1, 
  sheet.getLastColumn()).moveTo(targetRange);
      sheet.deleteRow(range.getRow());
    }
  }
  </code></pre>