How to put down the time in the next cell?

Question

Working with date/time

Task:
Put down the current time in a neighboring cell when filling in another cell (Google Doc)
When using the formula =IF(A1<>0;now();"wait"), the time is substituted, but when I start filling in other cells in column A, changes throughout the formula column.
How to deal with it? It is necessary that after each filled cell in column A, a new time is entered in the adjacent cell, without affecting the cells with the time above.

Answer 1

Look for triggers

function onEdit(e) {
var ss = e.source.getActiveSheet();
  var r = e.source.getActiveRange();
  r.setComment("Изменено: " + Utilities.formatDate(new Date(), "GMT+3", "dd-MM-yyyy HH:mm:ss"));
}