function myF10() {
myAction("F10", "=IFERROR(VLOOKUP(B10;'Эта неделя'!$B$3:$E$120;3;FALSE);0)", 6)
/** и т.д. */
}
function myAction(range, formula, number) {
const list = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet() ;
list.getRange(range).setFormula(formula);
let range2 = list.getLastRow();
range2 = list.getRange(10, number, range2-9);
list.getRange(range).copyTo(range2) ;
}
В чем тогда смысл?