Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e){
- const criteriaSheet = 'Turbo'
- if (e.source.getActiveSheet().getName() == criteriaSheet){
- const email = Session.getActiveUser().getEmail()
- const now = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "yyyy-MM-dd hh:mm");
- e.source.getActiveSheet().getRange("C4:D4").setValues([[email,now]]);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement