Automation Idea's in Google Sheets: Automatically Add Timestamps
There are many great built in features in Google Sheets but adding a timestamp whenever an action occurs is not a native feature to Google Sheets. Luckily we have Apps Script which allows automation to occur directly within Google Sheets.
Don't know how to code? No worries. I don't either. As long as you can follow instructions, you can take my code and easily adjust it to meet your exact needs for your projects.
In this video, you'll see how to:
Add a timestamp based on a value occurring.
Add a timestamp when a cell is no longer empty
Alteration Ideas
Troubleshooting
00:00 - Intro
00:11 - Timestamp focus
01:17 - Add automation code when a value is selected
03:17 - Quick code explanations to know how to update it for your use.
05:38 - Add timestamp when cell is no longer blank
06:14 - Adjust column location
06:52 - Add new trigger
07:43 - Overwrites existing timestamps
07:54 - New Section
09:14 - Troubleshooting in action
10:44 - Summary
11:32 - Outro