Auto-Add Date and Time to an Adjacent Cell Upon Edit in Google Sheets with Apps Script
10.2 هزار بار بازدید -
پارسال
-
In this tutorial, you'll learn
In this tutorial, you'll learn how to automatically add a date to an adjacent cell in a Google Sheet when it is edited with a little Google Apps Script magic.
This is an incredibly useful script to add date-time stamp cells to actions that occur in your Google Sheets.
This video tutorial covers the basic process, but there are a large number of variations to this that I have collected over the years and added to the written tutorial.
To the written tutorial: https://yagisanatode.com/add-the-curr...
** More on OnEdit() **
- Add an email onEdit() (For domain workspace accounts): Add an Editor's Email when a Checkbox...
- Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets: https://yagisanatode.com/google-apps-...
** My Site **
https://yagisanatode.com/
** More on Google Apps Script **
https://yagisanatode.com/google-apps-...
** Products **
Create and Publish Google Workspace Add-ons with Google Apps Script: Master Class https://yagisanatode.com/products/cre...
* Courses *
https://yagisanatode.com/products-cat...
* Google Workspace Tools *
https://yagisanatode.com/products-cat...
* Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#googleworkspace #googleappsscript #googledrive #googlesheets #mp4 #videoediting #admin #businessadministration @googleworkspacedevs
This is an incredibly useful script to add date-time stamp cells to actions that occur in your Google Sheets.
This video tutorial covers the basic process, but there are a large number of variations to this that I have collected over the years and added to the written tutorial.
To the written tutorial: https://yagisanatode.com/add-the-curr...
** More on OnEdit() **
- Add an email onEdit() (For domain workspace accounts): Add an Editor's Email when a Checkbox...
- Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets: https://yagisanatode.com/google-apps-...
** My Site **
https://yagisanatode.com/
** More on Google Apps Script **
https://yagisanatode.com/google-apps-...
** Products **
Create and Publish Google Workspace Add-ons with Google Apps Script: Master Class https://yagisanatode.com/products/cre...
* Courses *
https://yagisanatode.com/products-cat...
* Google Workspace Tools *
https://yagisanatode.com/products-cat...
* Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#googleworkspace #googleappsscript #googledrive #googlesheets #mp4 #videoediting #admin #businessadministration @googleworkspacedevs
پارسال
در تاریخ 1402/04/17 منتشر شده
است.
10,240
بـار بازدید شده