Google-Sheets-Logger

This is a spreadheet where you can write completed tasks and archive them when your done. You can also add them to a category.

Link to copyable Goolge Sheet: https://docs.google.com/spreadsheets/d/1AKjV3JM1nci-H9CzG0O7gb_8yjItCqwCvW8YBFnk318/edit?usp=sharing

Click to Play Video:

Notes:

• This is for Google Sheets
• This uses Googe's app script editor.

How to use:

Create a new google sheet that looks like the template sheet. Go to tools, then script editor. Add the code into the script and hit save.

Journal

• 2019.01.28 Added template Spreadsheet and code for the spreadsheet. Showcase
• 2019.04.01 LuisC Added a custom menu for logging. Showcase
• 2019.04.02 Added Buttons for logging so that there are less clicks to log and shorter wait time than creating a custom menu. Showcase

References:

• How to create a Google Sheet Button to Run Script
• Google Sheets API Documentation