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
10 сен 2022