I am a complete beginner and just trying to make an interface that the rest of my family can use for budgeting. The only thing I am struggling with is the automation of the last modified date for certain cells. Whenever I run the code as an add-on it only modifies column 7 as specified in the first statement even if I enter the code into column 10,11,15,etc. seemingly ignoring the other “else if” statements.
function onEdit(e) {
var row = e.range.getRow();
var col = e.range.getColumn();
if(col === 5,6 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,7).setValue(new Date());
}
else if(col === 10,11 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,12).setValue(new Date());
}
else if(col === 15,16 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,17).setValue(new Date());
}
else if(col === 20,21 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,22).setValue(new Date());
}
else if(col === 25,26 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,27).setValue(new Date());
}
else if(col === 30,31 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,32).setValue(new Date());
}
else if(col === 35,36 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,37).setValue(new Date());
}
else if(col === 40,41 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,42).setValue(new Date());
}
else if(col === 45,46 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,47).setValue(new Date());
}
else if(col === 50,51 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,52).setValue(new Date());
}
else if(col === 55,56 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,57).setValue(new Date());
}
else if(col === 60,61 && row > 3 && e.source.getActiveSheet().getName() === "2021" ){
e.source.getActiveSheet().getRange(row,62).setValue(new Date());
}
}
Aucun commentaire:
Enregistrer un commentaire