I have a little function for controlling the values of my script:function onEdit(event) {  var rowIndex = event.source.getActiveCell().getRowIndex();  var columnIndex = event.source.getActiveCell().getColumnIndex();  var status = event.source.getActiveCell().getValue();  Browser.msgBox(Spalte: +String(rowIndex) +  Zeile:  + String(columnIndex));  Browser.msgBox(inhalt: +String(status));}It is a on edit function which gives me the position of my edited cell and the content. (I have the variable status for the content or value of the active cell).My question is: how do I have to change the function if I want to have the content of the previous cell in the same column?I tried to navigate directly with: +String(H2)); (no result)I tried to go with: +String(status)-1); (no result) Is it necessary to have another variable first which gives me the value of the previous cell?
Show the content of an edited cell in a message box above
google spreadsheets;google apps script