title: running script on an Inactive sheet
body: <p>I have been using the following script to move "Finished" columns from one sheet to another:</p>
  
  <pre><code>function onEdit(event) {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var s = event.source.getActiveSheet();
    var r = event.source.getActiveRange();
  
    if(s.getName() == "Sheet1" &amp;&amp; r.getColumn() == 15  &amp;&amp; r.getValue() == 
  "Finished") {
      var row = r.getRow();
      var numColumns = s.getLastColumn();
      var targetSheet = ss.getSheetByName("Finished");
      var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
      s.getRange(row, 1, 1, numColumns).moveTo(target);
      s.deleteRow(row);
    }
  }
  </code></pre>
  
  <p>Im trying to figure out how to get the script to run even if the sheet has not been opened or edited. Im just not sure how to go about changing it to use a time trigger every minute or so. </p>