https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}
function sortSheets() {
const rangesInfo = [
{sheet: "2022", range: "A2:M", column:3, ascending: true},
{sheet: "Выполнено_2022", range: "A2:M", column:3, ascending: true},
];
let ss = SpreadsheetApp.getActiveSpreadsheet();
rangesInfo.forEach(rangeInfo=>{
try{
let range = ss.getSheetByName(rangeInfo.sheet).getRange(rangeInfo.range);
range.sort({column: rangeInfo.column, ascending: rangeInfo.ascending});
}catch(err){
Logger.log(`error: ${err}`);
};
});
}
=OR(
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
;INDIRECT("RC[3]";0)<>""
;INDIRECT("RC[4]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
;INDIRECT("RC[3]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[-3]";0)<>""
;INDIRECT("RC[1]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[-3]";0)<>""
;INDIRECT("RC[-4]";0)<>""
)
)