Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(event)
- {
- var ss = event.source.getActiveSheet();
- var r = event.source.getActiveRange();
- var today = new Date();
- var date = Utilities.formatDate(today, "EST", "MM/dd/yyyy hh:mm a")
- var col = r.getColumn();
- var sheetname = ss.getName();
- r.setComment("Last modified: " + "(" + date + ")" );
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement