79494446

Date: 2025-03-08 13:28:35
Score: 5.5
Natty:
Report link

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());       
        }
      }
    }
}
Reasons:
  • Blacklisted phrase (0.5): how can I
  • Blacklisted phrase (0.5): I need
  • Blacklisted phrase (1): enter image description here
  • RegEx Blacklisted phrase (3): Can anyone help
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Pawan Choudhary