Google App Script - Make numeric entries 0 if conditions in another column match

function createXml(e) {
  var data = [["clipitem-1","video",1,1],["clipitem-2","audio",1,2]];
  var xml ='<xmeml version="4"><sequence><clipitem>';
  for(var i=0;i<data.length;i++){
    xml+="<link><linkclipref>"+data[i][0]+"</linkclipref><mediatype>"+data[i][3]+"</mediatype><mediatype>"+data[i][3]+"</mediatype></link>"
  }
  xml+="</clipitem></sequence></xml>";
  var blob = Utilities.newBlob(xml, 'text/html', e.parameter.filename + '.xml');
  return blob;
}

function checkScriptCheck() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Sheet1");

  var datePaymentRange = sheet.getRange("A:A");
  var datePaymentValues = datePaymentRange.getValues();
  var dateInputValues = sheet.getRange("B:B").getValues();

  var datePaymentColumn = datePaymentRange.getColumn();
  var checkResultValueColumn =sheet.getRange("C:C").getColumn()

  //cleaning color
  datePaymentRange.setBackground("white");

  //create map of values to check for
  var inputDates = {};
  for (var i = 1; i < dateInputValues.length; i++) { // Exclude header row
    var inputDate = dateInputValues[i][0];
    if (inputDate != "") { // Exclude blank values
      inputDates[inputDate] = true;
    }    
  }

  //check and coloring
  for (var i = 1; i < datePaymentValues.length; i++) { // Exclude header row
    var paymentDate = datePaymentValues[i][0];
    if (inputDates[paymentDate]) {
      sheet.getRange(i+1, datePaymentColumn).setBackground("#00ff00");
      sheet.getRange(i+1, checkResultValueColumn).setValue("check");
    }
  }
}

function getRowIndex() {
  var lookupValue = "car";
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("List");
  var lastRow = sheet.getLastRow();
  var lookupRangeValues = sheet.getRange(1, 1, lastRow, 1).getValues();
  var index = -1;
  lookupRangeValues.forEach(function (row, i){
     if (row[0] == lookupValue )
     {
       index = i;
       return (false);
     }
  });
  Logger.log(index);
}

function findCats() {
  var ss=SpreadsheetApp.getActive();
  var sh1=ss.getSheetByName('Sheet1');
  var rg1=sh1.getRange(2,1,sh1.getLastRow()-1,sh1.getLastColumn()+1);
  var vA1=rg1.getValues();
  var sh2=ss.getSheetByName('Sheet2');
  var rg2=sh2.getRange(2,1,sh2.getLastRow()-1,sh2.getLastColumn());
  var vA2=rg2.getValues();
  var obj2={nA:[]};
  for(var i=0;i<vA2.length;i++) {
    obj2[vA2[i][0]]=vA2[i][1];
    obj2.nA.push(vA2[i][0]);
  }
  for(var i=0;i<vA1.length;i++) {
    var idx=obj2.nA.indexOf(vA1[i][0]);
    if(idx>-1) {
      vA1[i][2]=obj2[vA1[i][0]];
    }
  }
  rg1.setValues(vA1);
}

function so5664033702() {
  var ss=SpreadsheetApp.getActive();  
  var tarsheet=ss.getSheetByName('Old Categories');
  var tarLC =tarsheet.getLastColumn();
  var tarLR = tarsheet.getLastRow();
  var tarRange=tarsheet.getRange(2,1,tarLR-1,tarLC);
  //Logger.log("DEBUG: Target range ="+tarRange.getA1Notation());
  var tarValues=tarRange.getValues();
  // get the Cat2 values so that the range can be easily updated after the loop
  var tarcat2Range = tarsheet.getRange(2,6,tarLR-1);
  //Logger.log("DEBUG: Target Cat2 range ="+tarcat2Range.getA1Notation());
  var tarcat2Values = tarcat2Range.getValues();
  var srcsheet=ss.getSheetByName('New Categories');
  var srcLR = srcsheet.getLastRow();
  var srcRange=srcsheet.getRange(2,1,srcLR-1,3);
  //Logger.log("DEBUG: Source Range ="+srcRange.getA1Notation());
  var srcValues=srcRange.getValues();
  // create array to build names  
  var tarNames = [];
// loop through Old Category Names to pupulate the array  
  for (z=0;z<tarValues.length;z++){
    tarNames.push(tarValues[z][1]);
  }   
  // loop through the new category Names to find the match on Old Categories
  // the value "c" will be the row number.
  for (i=0;i<srcValues.length;i++){
    var c = tarNames.indexOf(srcValues[i][0]);
    //Logger.log("DEBUG: c = "+c+", value: "+srcValues[i][0]+", cat2:"+tarcat2Values[c][0] +", new Cat2:"+srcValues[i][2]);
    // if c = -1, then there is no match; otherwise update the OldCategory/category2 value with the value from New category
    if (c!=-1){
      tarcat2Values[c][0] = srcValues[i][2];      
    }
  } // end of the New category Loop
  // setValues for the Cat2 range with the updated values.
  tarcat2Range.setValues(tarcat2Values); 
}

function countingBuckets() {
  var ss=SpreadsheetApp.getActive();
  var sh=ss.getSheetByName('b');
  var rg=sh.getRange(1,1,sh.getLastRow(),2);
  var vA=rg.getValues();
  var cb={bA:[]};
  vA.forEach(function(r,i){
    if(!cb.hasOwnProperty(vA[i][0])) {
      cb[vA[i][0]]=vA[i][1];
      cb.bA.push(vA[i][0]);
    }else{
      cb[vA[i][0]]+=vA[i][1];
    }  
  });
  sh.appendRow(["Results"]);
  cb.bA.forEach(function(e,i){
    sh.appendRow([e,cb[e]]);
  });
}

function countingBuckets() {
  var ss=SpreadsheetApp.getActive();
  var sh=ss.getSheetByName('b');
  var rg=sh.getRange(1,1,sh.getLastRow(),2);
  var vA=rg.getValues();
  var cb={bA:[]};
  vA.forEach(function(r,i){
    if(!cb.hasOwnProperty(vA[i][0])) {
      cb[vA[i][0]]={cells:0,sum:0};
      cb[vA[i][0]].sum=vA[i][1];
      cb[vA[i][0]].cells=1;
      cb.bA.push(vA[i][0]);
    }else{
      cb[vA[i][0]].sum+=vA[i][1];
      cb[vA[i][0]].cells+=1;
    }  
  });
  sh.appendRow(["Results"]);
  cb.bA.forEach(function(e,i){
    sh.appendRow([e,cb[e].sum,cb[e].cells]);
  });
}