If I make changes manually, DATE function is triggered and it works fine. But if the changes is not made by me and it is made automatically based on some condition, onEdit() is not triggered.
Can anyone help how can I achieve my requirement? I need the date/time to capture automatically whenever there is any change in a cell of google sheet. This is image of my Google sheet. enter image description here
Find below my function.
----------------------------------------------------------------------------
function onEdit(e){
if( e.range.getSheet().getName() === "TEST" ) {
if(e.range.columnStart === 3 && e.range.rowStart >= 2){
if(e.value === "SORT" || e.value ==="lONG"){
e.range.offset(0,1).setValue(new Date());
}
}
}
}