Google Spreadsheet - Update Log

Using google spreadsheet to be your update log sheet.
With this app script, u may easy to find which task have not done yet
With this app script, u may easy to assign color to each status
With this app script, we are saving your mouse click to prepare new lines
Lets me show the result to you first

Google Spreadsheet - update log

Installation

1. Step: Make a copy from: Update Log Template, rename the softcopy
2. Step: Copy the spreadsheet Key ID, this is a unique identify code in the URL
   https://docs.google.com/spreadsheet/ccc?key=This is your spreadsheet key#gid=0
3. to Go to the app script, Press Tools > Script editor ...
4. replace the spreadsheetID value by sheet key your just copy, please kindly note that another properties I will explain later

Demonstration

1. Step: Make a copy from: Update Log Template, rename the softcopy
2. Step: Copy the spreadsheet Key ID, this is a unique identify code in the URL
   https://docs.google.com/spreadsheet/ccc?key=This is your spreadsheet key#gid=0
3. to Go to the app script, Press Tools > Script editor ...
4. replace the spreadsheetID value by sheet key your just copy, please kindly note that another properties I will explain later

====================================================================

GitHubs

• https://github.com/keithbox/Google-Spreadsheet-Update-Log

Reference

• 試試新推出的 Google 試算表
• Google 試算表的大小和複雜度上限
• 套用條件式格式設定規則