javascript
1function triggeredCutPaste() {
2 const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
3 const src = spreadsheet.getSheetByName("元");
4 const dst = spreadsheet.getSheetByName("先");
5 copyPaste(src, dst);
6 deleteRows(src);
7}
8function copyPaste(src, dst) {
9 const finished = src.getDataRange().getValues()
10 .filter(function(element, index, array) {
11 return element[6] === "完了";
12 });
13 if(finished.length > 0) {
14 dst.getRange(dst.getLastRow() + 1, 1, finished.length, finished[0].length).setValues(finished);
15 }
16}
17function deleteRows(sheet) {
18 sheet.getDataRange().getValues()
19 .map(function(element, index, array) {
20 return [index + 1, element[6]]
21 }).filter(function(element, index, array) {
22 return element[1] === "完了";
23 }).map(function(element, index, array){
24 return element[0];
25 }).reverse().forEach(function(element, index, array){
26 sheet.deleteRow(element);
27 });
28}