-1
If column 6 is not Empty, the script stamps "make loans" in column 13. I tried to accomplish something like script below, because it could be done by a formula, but it cannot have formulas in this column Nº 13.
How could I adjust a script for this event ?
function onEdit() {
var ActiveSheet= SpreadsheetApp.getActiveSheet();
var capture = ActiveSheet.getActiveCell();
if(capture.getColumn() == 6 && ActiveSheet.getName() == 'PLANILHA DE ATIVIDADES') {
var add = capture.offset(0, +13);
var write = "realizar empréstimos;
}
}