title: If and when my user put data in Column A, Column B should auto populate who the editor is in Google Spreadsheet?
body: <p>I am on google domain (G Suite). I would like to have this simple task of getting the editor/user name of a cell in column B of a spreadsheet as soon as s/he edit the cell in column A of the same row.</p>
  
  <p>I have found and used a few sets of Google script, such as one below, but they didn't work unfortunately.</p>
  
  <pre><code>function checkEdits() {
  var SS = SpreadsheetApp.getActiveSpreadsheet();
  var sheet1 = SS.getSheetByName('Sheet1');
  var specialCell = sheet1.getRange("A:A");
  
  if (SS.getActiveCell().getA1Notation() == specialCell.getA1Notation()) {
  var htmlEmail = "Cell " + specialCell.getA1Notation() + 
    " edited by " + Session.getActiveUser().getEmail();
  GmailApp.sendEmail("YOUR EMAIL HERE", "Spreadsheet Update " + new Date(), "", {htmlBody:htmlEmail} );
   }
  }
  </code></pre>
  
  <p>Thank you very much!</p>