Рет қаралды 12,240
This video covers adding Date and Time Stamps to specific columns in Google Sheets using the Apps Script onEdit() Function. In the first example we look at adding a Date/Time Stamp to Column B based on a new value being added to the same row in Column A and also assuming the Value in Column B is empty. In other words, this is a "one-time" only Date/Time stamp that does not update again if the same row in Column A is edited. In the second example we look at adding a Date/Time Stamp that refreshes each time a corresponding row in an adjacent column is updated.
Learn more about Google Apps Script with this Beginner's Guide Book at Amazon.
amzn.to/3MMvDZs
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below
#GoogleAppsScriptOnEdit
#GoogleAppsScriptAddTimeStamp
#GoogleAppsScriptAddTimeStampOnEdit