0
I made the following code to iterate and take the value of two columns, B and E. If "B" contains the value SIM and "E" is empty, it adds "1" to the counter, and returns the sum at the end. However, when executing the code, it gives the following error: Interval not found (line 12, file "tste2") Line 12 is identified in the code. I don’t know what could be wrong.
function toastAlerta() {
var planilha = SpreadsheetApp.getActiveSpreadsheet();
var semEvid = 0;
for (var i=0;i<23;i++){
var resp = sh.getRange('B'+i).getValue(); //linha 12
var evid = sh.getRange('E'+i).getValue();
if ((resp == 'SIM') && (evid == '')) {
semEvid+=1;
}
}
Logger.log('Respostas sem evidencias: ' + semEvid);
}
Read: https://answall.com/q/411417/101
– Maniero
I see. Grateful.
– Roger Regor