質問編集履歴
1
コードの修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -17,9 +17,10 @@
|
|
|
17
17
|
const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
|
|
18
18
|
const sheet = spreadsheet.getSheetByName("●●●"); // シートの取得
|
|
19
19
|
const lastRow = sheet.getLastRow();
|
|
20
|
-
const Status = sheet.getRange(i, 1).getValue()
|
|
21
20
|
|
|
22
21
|
for(let i = 2; i <= lastRow; i++) {
|
|
22
|
+
|
|
23
|
+
const Status = sheet.getRange(i, 1).getValue()
|
|
23
24
|
|
|
24
25
|
if (Status == "●●●") {
|
|
25
26
|
|