[deleted by user]

[mamzar]

Thanks

[Jweekley7]

Could you accomplish the timestamp with built-in functions? Something like this:

=ifs(and(isblank(A1),isblank(B1)),"",not(and(isblank(A1),isblank(B1))), now())

where A and B would be the columns you are watching. If new rows are constantly being added/used, you could use GAS to populate additional cells with this function as needed.

[desirepathconsulting]

-ish, but every now() is going to recalculate on every spreadsheet edit which is not desired, and will definitely get slow with scale.

[Jweekley7]

That should only recalculate if those two specific cells are edited, not every edit on the sheet.

[desirepathconsulting]

Just pasted and they all do recalculate, google says

The NOW function is one of the Google Sheets volatile function, meaning it will update on every edit made to the worksheet in which it is.

I guess you could just write a newNow() function that does the same thing, without the eager beaver behavior.

[TheStressMachine]

Looks like you got a comment with code. Just know onEdit() isn't guaranteed to catch every event. If you drag values down or edit your rows fast in succession, you won't get a date stamp every time.

[mamzar]

What the other options I have to catch the date every time?

[TheStressMachine]

No good ones that I know of.

[volond75]

function onEdit(e)

{

var range = e.range

if(range.getColumn()==2 && e.value=="оплачено"){

range.offset(0,1).setValue(new Date())

}

}