function changestatus() {
var mainsh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('main')
var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('data')



let ar = mainsh.getActiveCell();
let valueToSet = ar.getValue();
let valueToFind = ar.offset(0, -1).getValue();
Logger.log(valueToSet)
Logger.log(valueToFind)


var _arr2 = sh.getRange('b:d');
var _arr1 = sh.getRange('b:d').getValues()

var status = mainsh.getRange('b:d').getValues().filter(function (row) { return row[3] });
for (var i = 0; i < _arr1.length; i++) {
//Logger.log(_arr1[i][1]

if (_arr1[i][1] == valueToFind) {

Logger.log("if" + _arr1[i][1]);
return _arr1(i,2).setValue(valueToSet)

}
}
}