I am using the code below. He copies the value he finds to another page and adds formulas. Finally pasting values to remove formulas. My problem is: pasting values directly without being able to add formulas. I could not solve this problem. I'm waiting for your help.
ss.getSheetByName('güncel').insertRowsBefore(ss.getRange('2:2').getRow(), 1);
ss.getActiveRange().offset(0, 0, 1, ss.getRange('2:2').getNumColumns());
var target = ss.getSheetByName('güncel').getRange(2, 1);
sh.getRange(f.getRow()-d, 1, 1,ss.getSheetByName('matbaaya_giden').getLastColumn()).copyTo(target, SpreadsheetApp.CopyPasteType.PASTE_VALUES, false); // Modified
var guncelbaski = shh.getRange(2, 7);
var baskinoarttir = ['=ARRAYFORMULA(LARGE(IF(matbaaya_giden!B:B=B2;matbaaya_giden!G:G;"");1))+1'];//BASKI NUMARASINI +1 ARTTIRMA
guncelbaski.setFormula(baskinoarttir);
var gunceltalep = shh.getRange(2, 3);
var sonbaskitalep = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!N$2:N))'];//SON BASKI TALEP TAR?H?. BASKIYA G?N TAR?H? GEL?R BURAYA
gunceltalep.setFormula(sonbaskitalep);
var guncelisbn = shh.getRange(2, 8);
var sonbaskiisbn = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!H$2:H))'];//SON BASKI ISBN
guncelisbn.setFormula(sonbaskiisbn);
var guncelfiyat = shh.getRange(2, 9);
var sonbaskifiyat = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!I$2:I))'];//SON BASKI F?YAT ?EK
guncelfiyat.setFormula(sonbaskifiyat);
var guncelebat = shh.getRange(2, 11);
var sonbaskiebat = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!K$2:K))'];//SON BASKI EBAT ?EK
guncelebat.setFormula(sonbaskiebat);
var guncelsayfa = shh.getRange(2, 12);
var sonbaskisayfa = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!L$2:L))'];//SON BASKI SAYFA ?EK
guncelsayfa.setFormula(sonbaskisayfa);
var guncelozellik = shh.getRange(2, 13);
var sonbaskiozellik = ['=ARRAYFORMULA(LOOKUP(2;1/((matbaaya_giden!$B$2:$B=$B2)*(matbaaya_giden!$G$2:$G=G2-1));matbaaya_giden!M$2:M))'];//SON BASKI ?ZELL?K ?EK
guncelozellik.setFormula(sonbaskiozellik);
//shh.getRangeList(['N2', 'R2'])//BURADAK? HüCRELER?N ARKA PLAN DOLGULARINI SIFIRLAMA
// shh.getRangeList(['N2', 'R2']).setBackground(null);
shh.getRange('S2').clear();
var gunceluretkutusu = shh.getRange('S2');
gunceluretkutusu.setDataValidation(SpreadsheetApp.newDataValidation()
.setAllowInvalid(false)
.requireCheckbox()
.build());
// shh.getRange('S2').activate();
shh.getRange('S2').setValue('FALSE');
shh.getRange('S2').setFontColor('#000000')
.setBorder(true, true, true, true, true, true, '#000000', SpreadsheetApp.BorderStyle.SOLID);
var rangesAddrebitensayfasiesList = [ 'D2:E2', 'J2', 'N2:R2', 'Z2:AL2'];
shh.getRangeList(rangesAddrebitensayfasiesList).clearContent();
shh.getRange(2, 1).setFormula('=IFERROR(IF(G2<>0;IF(ARRAYFORMULA(LARGE(IF(matbaaya_giden!B:B=B2;matbaaya_giden!G:G;"");1))=G2-1;ARRAYFORMULA(LARGE(IF(matbaaya_giden!B:B=B2;matbaaya_giden!G:G;"");1)) & ". Bask? ?";"Bask?y? Kontrol Ediniz.");"");"")');
//r.setValue(false);//üSTTEK? FORMüL BAKSI NO KONTROLü EKLER
shh.getRange(2, 3, 1, 25).copyTo(shh.getRange(2, 3, 1,25), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);// GüNCELDEK? BASKI NOSUNDAK? FORMüLü KALDIRIR.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…