質問編集履歴
1
コードの修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -17,10 +17,11 @@
|
|
|
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++) {
|
|
23
22
|
|
|
23
|
+
const Status = sheet.getRange(i, 1).getValue()
|
|
24
|
+
|
|
24
25
|
if (Status == "●●●") {
|
|
25
26
|
|
|
26
27
|
if(!sheet.getRange(i, 5).getValue()){
|