Iteration Googleappscript

Asked

Viewed 32 times

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

  • I see. Grateful.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.