Google-sheets – record the users within a Google sheet

google sheetsgoogle-apps-scriptgoogle-sheets-timestamp

I'd like to have an auto-generated list of users with timestamps within a spreadsheet, tabs, or if possible specific cells.

Ideally, once a cell has been altered, I'd like another cell to record the information of which user and the timestamp. Then when that same cell is altered, a new name and timestamp is recorded without deleting the old name and timestamp. I'd like to be able to set it up for multiple cells within a spreadsheet.

I've seen the onEdit and onOpen triggers but the data recorded is replaced with the newest information without a log of the old information.

Is there a way to have a continuous timestamp record of all users within a spreadsheet and ideally that information recorded for specific cells?

Best Answer

It's very likely that you are using something like

range.setValue(timestamp)

Instead use something like

range.setValue(range.getValue() +'\n' + timestamp);

Related Solutions

Google-sheets – How to get an onEdit script to run on a Google Spreadsheet for all users

It turned out that a bug in my script was stopping it from running. For anyone who stumbles across this question trying to solve a similar problem here is my working script:

function onEdit(event){
  var sheet = event.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();

  var tableRange = "A2:F999";

  if(editedCell.getColumn() == 6){   
    var range = sheet.getRange(tableRange);
    range.sort([{column: 6}, {column: 4}, {column: 5}]);
  }
}

Google-sheets – How to create a Google Spreadsheets whose name and cells auto-complete with cells completed on another sheet

I think you should be looking in the direction of using a single form to more or less accomplish both tasks. In other words use the form to populate both the Gantt chart AND the new project sheet.

Best Answer

Related Solutions

Google-sheets – How to get an onEdit script to run on a Google Spreadsheet for all users

Google-sheets – How to create a Google Spreadsheets whose name and cells auto-complete with cells completed on another sheet

Related Topic