AUTO ADD TIMESTAMP FOR EVERY ENTRY

Published: 01 January 1970
on channel: WatchNLearnIT

1,068

In this video I will show you on how to automate adding timestamp for every entry.

Here is the Google Appscript below:
===================START HERE=============
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "Sheet1" ) { //checks that we're on Sheet1 or not
var r = s.getActiveCell();
if( r.getColumn() == 1 ) { //checks that the cell being edited is in column A
var nextCell = r.offset(0, 1);
if( nextCell.getValue() === '' ) //checks if the adjacent cell is empty or not?
nextCell.setValue(new Date());
}
}
}
===================END HERE=============

CHECK OUT OTHER VIDEOS

ONE CLICK TO COPY THE WHOLE SHEET AND PASTE TO OTHER SHEET
   • ONE CLICK COPY AND PASTE SHEET1 VALUE...

POINT OF SALE TOOL USING GOOGLE SHEET
   • Google Sheet - Point of Sale

MAKE YOU SEARCH BOX IN GOOGLE SHEET
   • Google Sheet - Make your own Search B...

AND MANY MORE.....
   • GOOGLE SHEET TUTORIALS

#googlesheets
#auto
#timestamps

Watch video AUTO ADD TIMESTAMP FOR EVERY ENTRY online without registration, duration hours minute second in high quality. This video was added by user WatchNLearnIT 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,068 once and liked it 19 people.