Google-Scripts-Move-Rows-Automatically/MoveRows at master · aplater/Google-Scripts-Move-Rows-Automatically · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
function onEdit(e) {
  myFunction2();
}


function myFunction2() {
  // moves a row from a sheet to another when a value is entered in a column

  var sheetNameToWatch = "ToDo";

  var columnNumberToWatch = 8;
  var valueToWatch1 = "Doing";
  var sheetName1ToMoveTheRowTo = "Doing";

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch1) {

    var targetSheet = ss.getSheetByName(sheetName1ToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
    sheet.deleteRow(range.getRow());
  }

  var sheetNameToWatch = "ToDo";

  var columnNumberToWatch = 8;
  var valueToWatch2 = "Done";
  var sheetName2ToMoveTheRowTo = "Done";

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch2) {

  var targetSheet = ss.getSheetByName(sheetName2ToMoveTheRowTo);
  var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
  sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
  sheet.deleteRow(range.getRow());
}

  var sheetNameToWatch = "Doing";

  var columnNumberToWatch = 8;
  var valueToWatch2 = "Done";
  var sheetName2ToMoveTheRowTo = "Done";

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch2) {

    var targetSheet = ss.getSheetByName(sheetName2ToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
    sheet.deleteRow(range.getRow());
  }}