function _onEdit(e) {
let sheet = e.source.getActiveSheet();
let address = e.range.getA1Notation().toUpperCase();
let row = e.range.getRow();
let col = e.range.getColumn();
let newValue = e.value;
let oldValue = e.oldValue;
if ((["1"].includes(sheet.getName())) && (col===26) && (newValue==="Обработано")) {
sheet.getRange(row, 26-2).setValue(new Date());
};
};let foundItem = discordPayload.embeds[0].fields.find(x=>x.name==="Что требуется оформить");
if(foundItem && foundItem.value==="Отчет по контракту"){
// 1 вариант
};
https://web.whatsapp.com/send?phone=799988776655&text=Я+не+спамер=ArrayFormula(LAMBDA(x;y;c;filter({x\y};НЕ(ЕНД(ПОИСКПОЗ(y;c;0)))))(A2:A;B2:B;E2:E))=QUERY({Формула_1};"SELECT Col1,Count(Col1) GROUP BY Col1 PIVOT Col2")let obj = {
a: {
b: {
c: 'target'
}
}
};
let target = "target";
let lineIndex = JSON.stringify(obj, null, " ").split("\n").findIndex(t=>-1!==t.indexOf(target)); // +1 если нужен номер, а не индекс=ArrayFormula(QUERY({A3:B\0+C3:C};"SELECT Col2,Sum(Col3) GROUP BY Col2 PIVOT Col1"))function _onEdit(e) {
let sheet = e.source.getActiveSheet();
let address = e.range.getA1Notation().toUpperCase();
let newValue = e.value;
if(!(["Лист1"].includes(sheet.getName()))){
return;
};
if (address==="A1") {
let outRange = sheet.getRange("C1");
let outValue = +newValue+outRange.getValue();
outRange.setValue(outValue);
return;
};
if (address==="B1") {
let outRange = sheet.getRange("C1");
let outValue = -newValue+outRange.getValue();
outRange.setValue(outValue);
return;
};
};=ArrayFormula(5000*LAMBDA(x;x/СУММ(x))(RANDARRAY(10)))if (row[2] == 0 || row[2] == '') {const dateFormat = "yyyy-MM-dd";
let now = Utilities.formatDate(new Date(), "UTC", dateFormat);
// ...
if (now===Utilities.formatDate(row[2], "UTC", dateFormat)) {