google apps script - Simultaneously Running Function

Question

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.
            

Answer 1

等待大神答复