Short answer

From the rev 3 of the question

  

What is intended is that if after manually changing any cell of D61: 61 the value of C61 is greater than 0.25, the system sends a couple of e-mails. The same would happen with cells C62: C66

function onEdit(e){
  var fila = e.range.getRow();
  var columna = e.range.getColumn();
  if(columna < 3 && fila !== 61) return; // Salir cuando rango editado no sea D61:61 
  // Hacer lo que se tenga que hacer cuando el rango editado sea válido.
}   

Previous code

function onEdit(e){
  var celda = e.range.getA1Notation();
  var fila = celda.getRow();
  // Asumiendo que las celdas modificadas por el usuario a monitorear son
  var lista = ['C61','C62','C63','C64','C65','C66'];
  if(lista.indexOf(celda)){
    //Poner aquí lo que hay que hacer si la celda está en lista
  } else {
    // Poner aquí lo que hay que hacer si la celda no está enl a lista
  }
}

Broad response

With regard to what is indicated in the quote included above, you can use an activator when editing or changing to verify what happens in another part of the sheet, such as a calculation made by formulas

NOTE: One must keep in mind the asynchrony between the event and the recalculation. When they are simple calculations it is very likely that they are faster than Apps Script. You can use SpreadsheetApp.sleep (milliseconds) to wait a certain time or you could save the previous values in properties and use something like "exponential backoff" to have a certain degree of tolerance to what delays the recalculation.

About the code, the variable e is not defined. It's not clear how you pass that variable from an onEdit (e) function, but it's probably not really relevant to the questions you ask.

  

1) - Is it possible to define a list of cells to check such that   ['C61', 'C62', 'C63', 'C64', 'C65', 'C66']

     

and do something like in python "cell in   ['C61', 'C62', 'C63', 'C64', 'C65', 'C66']

On the one hand Google Apps Script is based on JavaScript, so you can define the list of cells to check as an array of references practically as you have written

var lista = ['C61','C62','C63','C64','C65','C66'];

Then you can use getRangeList (a1Notations) to get an object RangeList or you can use Array methods like indexOf, each, some, every, map or use loops as for and while along with some of the getRange(a1Notation) , either from Class Sheet or from Class Spreadsheet to do things with items in the list.

  

2) -The "e.range" comes from trying to use an onEdit (e) function where "e"   It is an event. However, I am trying not to use an event. I do not   The use of triggers is clear. It seems that there are functions   "reserved" that are "self-triggered" as "onEdit (e)" and "onChange (e)"   when you edit or change a cell and others that do not, in need of   "external" triggers, what options do I have?

Reserved role names are indicated in link . These are used for simple triggers . onChange is not one of them. The installable activators are configured from the Edit menu from where you can select any function of the global scope of the project being edited.

Installable indicators are indicated in link .

In spreadsheets to execute a function when editing a function you can use a simple trigger onEdit , or an installable trigger when editing or when changing a spreadsheet.

Notes:

I think I already have a more refined version of what I want to do:

function sheetTracker() { 

// Version 2.0

var libro = SpreadsheetApp.getActiveSpreadsheet(); // Obtenemos a que libro pertenece la celda que ha cambiado
var hoja = libro.getActiveSheet().getName(); // Obtenemos el nombre de la hoja en la que ha cambiado la celda
var lista = ['C61','C62','C63','C64','C65','C66']; // Celdas a monitorizar
var celda = libro.getActiveCell().getA1Notation(); // Obtenemos el nombre de la celda que ha cambiado
var valor = Number(libro.getActiveCell().getValue()); // El nuevo valor de la celda

// Si no se ha modificado una celda de la hoja de asistencia que toca salimos

if (hoja != "Mi hoja") return; 

if (lista.indexOf(celda) && valor > 0.25) { 
       var fila     = libro.getActiveCell().getRow();
       var columna  = libro.getActiveCell().getColumn();
       var persona  = libro.getRange(fila,columna+2).getValue().toString();
       var email    = libro.getRange(fila,columna-2).getValue().toString();
       var yes      = libro.getRange(fila,columna+1).getValue();
       var justfied = libro.getRange(fila,columna-1).getValue();

       MailApp.sendEmail(email, subjecta, messagea); 
       MailApp.sendEmail(director, subjectd, messaged);


} else {
      return;
}
}

In the end, I opted for an installable trigger (discarding the use of the "onEdit (e)" function and its event e). To install the activator I would install an activator: on edit (go to resources> current sheet> activators> add new trigger) and authorize the script.

But the following question arises: is it correct to move to another cell to define the variables: person, email and justified, or should I use the offset () function?