Hello Good afternoon, Hope someone would help me with this,
i wanted to have two timestamp on my worksheet without using the google forms, so the logic is like this one, i am going to input the accomplishment column the first column which is the timestamp column will automatically generate the date and time (which is i already did and it's okay). But the second one is that when i approved/disapproved column approved it i need to see the last column which is the another timestamp column shows again the date and time of approving the accomplishment. https://docs.google.com/spreadsheets/d/1gOEe6bQIrZjR3X0ByTPL_Ya3BjJegCBOsB_SCYosCdc/edit?usp=sharing Here's my code: function onEdit(e) { if (e.range.columnStart !== 7 || e.source.getActiveSheet() .getName() !== 'Trial 1' || e.value == "") return; e.source.getActiveSheet() .getRange(e.range.rowStart, 1) .setValue(new Date()); then(); (e.range.columnStart !== 12 || e.source.getActiveSheet() .getName() !== 'Trial 1' || e.value == ""); e.source.getActiveSheet() .getRange(e.range.rowStart, 15) .setValue(new Date()); } /* Utilities.formatDate(new Date(), "GMT+0800", "yyyy-MM-dd:HH:MM"); */ Please do help me: Thank you -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
