Google-sheets – “Last Modified” function

google sheets

I have a problem in using Google Sheets. My sheet is shared with others so I want to add a "Last Modified" function in each row, so I can know when it was last modified.

I've searched Google for a solution but most are using scripts, and I don't know how to use scripts. I made a sheet, in which I just want a particular cell in a column to input the date and time whenever any cell in the same row is updated.

Best Answer

Short answer

There is no built-in function to do what you ask. If you don't want to use a script, the alternative is to use an add-on.

Extended answer

The related built-in functions are NOW() and TODAY() but they recalculate automatically. The only way to freeze them automatically is by using a script, to make things easier for end users developers could publish add-ons.

At this time I don't know of an add-on that does what you are looking for. Try to find one by yourself.

An alternative is to use a spreadsheet template that already has the script. The old template gallery have at least one, ubersimple AutoTimeStamp. I tried it some time ago, but I'm not sure that it's still working.

Note: The old template gallery will not be available later in 2016.

References

Related Solutions

Google-sheets – How to apply a script to every sheet but the first one on a spreadsheet

You can test if the active sheet is the first sheet with

sheet.getIndex() == 1

^(doc)

So your function can be

function onEdit() {
  var s = SpreadsheetApp.getActiveSheet();
  if (s.getIndex() == 1) {
     return; // Don't do anything for first sheet
  }
  var r = s.getActiveCell();
  if( r.getColumn() != 2 ) { //checks the column
    var row = r.getRow();
    var time = new Date();
    time = Utilities.formatDate(time, "GMT-08:00", "MM/DD/yy, hh:mm:ss");
    SpreadsheetApp.getActiveSheet().getRange('B' + row.toString()).setValue(time);
  };
};

Google-sheets – How to stop NOW function from auto-updating

Try Shift+Ctrl+: and Ctrl+;

Those are the keyboard shortcuts for "insert time" and "insert date" respectively.

(based on pnuts' comment)