need help this function dont work

234 views
Skip to first unread message

ShiizophreN

unread,
Jul 24, 2022, 1:15:20 AM7/24/22
to Google Apps Script Community
function onEdit(e) {
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet(); // Variable für das Dokument
  var member = sheet.getSheetByName('Damon'); // Variable für das Tabellenblatt Mitglieder
  var row = member.getDataRange().getLastRow(); // Variable der letzten Zeile
  var columns = ['R','R6'];
  var steuerFrei = `=SUM(1500*AD${row})+(P${row}*(index(Datenblatt!$A$1:$J$38;Match(O${row};Datenblatt!$A$1:$A$38;0);4)))`; 
  var steuern = `=SUM(1500*AD${row})+(P${row}*(index(Datenblatt!$A$1:$J$38;Match(O${row};Datenblatt!$A$1:$A$38;0);5)))`;

  columns.forEach((item) => {
    var range = member.getRange(item + row);
    if (item == columns[0] && range.getColumn() == 21 && range.getValue() == "Steuerfrei") { 
      range.setValue(steuerFrei); 
    }
 })
}

Edward Ulle

unread,
Jul 24, 2022, 10:25:16 AM7/24/22
to Google Apps Script Community
Let say row is 10, then range is either R10 or R610.  Since range is always R or 18 it will never be 21.
Reply all
Reply to author
Forward
0 new messages