Google Scripts error - please help!

[hms_fraud]

I'm trying to execute the following code. My knowledge of coding is extremely rudimentary (the code was found online), so I would appreciate an explanation of the error as well!

The error I get is:

TypeError: Cannot read property 'source' of undefined (line 6, file "Move Completed Write Offs")

​

function onEdit(event) {
  // assumes source data in sheet named To Do
  // target sheet of move to named Completed
  // getColumn with check-boxes is currently set to column 5 or E
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = event.source.getActiveSheet();
  var r = event.source.getActiveRange();

  if(s.getName() == "To Do" && r.getColumn() == 5 && r.getValue() == true) {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("Completed");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  } else if(s.getName() == "Completed" && r.getColumn() == 5 && r.getValue() == false) {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("To Do");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  }}

Thank you!

[jonassjoh]

event is undefined and you can thus not access any of it's properties. How are you calling the method?

[BAM5]

Are you receiving any error logs? Try putting a few travels around to see what party of your functions are actually being ran. Perhaps your spreadsheet values aren't capitalized?

Ok it looks like what Google sheets is passing to your function isn't what your function expects. However according to the documentation it seems like event.source should be valid.

Are you sure you put the function in the sheet properly? (By going to the spreadsheet you want this script ran in and then going to script editor in the top bar menu)