回答編集履歴
2
誤字の修正
answer
CHANGED
|
@@ -2,16 +2,18 @@
|
|
|
2
2
|
下記コードにて解決いたしました。
|
|
3
3
|
|
|
4
4
|
```ここに言語を入力
|
|
5
|
-
function
|
|
5
|
+
function set_last_update() {
|
|
6
6
|
|
|
7
|
-
|
|
7
|
+
var sh=SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
|
|
8
|
-
|
|
8
|
+
if (sh.getSheetName() == "日程") {
|
|
9
9
|
|
|
10
|
-
|
|
10
|
+
var activerange=sh.getActiveRange();
|
|
11
|
+
|
|
11
|
-
|
|
12
|
+
var activerow=activerange.getRow();
|
|
13
|
+
|
|
12
|
-
|
|
14
|
+
sh.getRange(activerow, 2).setValue(new Date());
|
|
15
|
+
|
|
13
|
-
|
|
16
|
+
}else{
|
|
14
|
-
|
|
15
|
-
}
|
|
16
17
|
}
|
|
18
|
+
}
|
|
17
19
|
```
|
1
誤字の修正
answer
CHANGED
|
@@ -5,7 +5,7 @@
|
|
|
5
5
|
function myFunction() {
|
|
6
6
|
|
|
7
7
|
var sheet = SpreadsheetApp.getActiveSheet()
|
|
8
|
-
if (sheet.getSheetName() == "
|
|
8
|
+
if (sheet.getSheetName() == "日程") {
|
|
9
9
|
|
|
10
10
|
|
|
11
11
|
var editRow = e.range.rowStart
|