I have 2 columns to enter Lat and Long coordinates in ( E and F ), those also contain the Formulas (for all rows, I just happened to choose row 768below)

=IFERROR("N"&left(index(Split(D768,"N"),1),11),"") 

and

=IFERROR("W"&index(Split(D768,"W"),2),"")

Because 75% of the time the full set of Coords can be pasted in D in which case the above seems to work fine in breaking it up into E and F properly or accepting manual input

The problem I'm having is with a script (copy below) that looks for changes in E and F and if so puts today's date in H. With Manual entries in E and F the script works great, with the Cut and Paste into D

however, it only works sometimes (maybe 10%). I could understand it either not working at all (because maybe using a formula not considered an edit?) or working all the time – But why does it work sometimes and/or how to fix it.

Script

function onEdit(e) {
 if ([5].indexOf(e.range.columnStart) != -1) {
 e.range.offset(0, 3).setValue(new Date());
 }
 if ([6].indexOf(e.range.columnStart) != -1) {
 e.range.offset(0, 2).setValue(new Date());
 }
}