If your to-do list is on Google sheet, this plugin can automates it further. If you do not have a to-do list yet, you can plug it into a blank Google sheet to get a basic template that you can change/format it further as you like.
To-do list plugin provides sorting which can be customized, moving completed task to the end, adding blank row when it is filled up, deleting row when task description is deleted and advancing the date when repeating task is ticked for completion. Month-end task when repeated will stay at month-end.
How to install?
- Open your existing to-do list Google sheet or a blank Google sheet.
- Go to Google Workspace Marketplace to install this add-on. After Installation, your sheet menu Extensions will have this add-on . If not, please re-open your sheet.
- From the menu, select 'Plug in'. If the opened sheet is blank, a template will be created for you. Otherwise, a sidebar will pop up for you to configure the plugin parameters, namely your to-do list sheet name, header row number, date column, task column and optional repeating frequency column and sorting columns.
How to use?
- You just edit your to-do list.
- After a cell which has column configured is editted, Google sheet will trigger this add-on to perform the following:
- For date edited, the task will be sorted according to date.
- For task ticked for completion, the task will be sorted to the end of the list.
- For a new task entered to an empty row, an empty row will be inserted.
- For repeating task ticked for completion, the task date will be advanced according to your given repeating frequency. The frequency can be in number of days (d), weeks (w), months (m) and years (y). The repeating frequency is expressed as nx where n is a number and x is d, w, m or y. For 'd', it is daily excluding weekend. For '1d', it is daily including weekend. For m and y, if the date is on month-end, the advanced date will be on month-end.
This plugin is using the Google sheet trigger onEdit which is processed in Google cloud. Depending on your network traffic, please allow one to a few seconds for your edits going to the cloud and have the refresh back to your device. You will notice the start and end of the refresh from the task header which changes color to red momentarily.
If refresh has mixed with your input, you can unplug and use Google sheet Undo (Ctrl-Z) to roll back the changes or use restore previous version. After a few times, you will get use to the Google onEdit trigger.
This add-on is free for personal use and for sponsors. If you are happy using this add-on, please become my supporter and sponsor.
Template Support Post install tip Donate Privacy policy Terms of service
Instead of processing one edit at a time, the add-on has been enhanced to group and process all edit at the time that it is triggered.
ReplyDeleteThe plugin configuration has a new optional input field 'Sort by column'. For example, if you have a priority column, you can override the default sorting to have priority column letter inside the sort sequence.
ReplyDeleteA user filled in my questionaire and received the owner key to end the greeting sidebar. Somehow when she submitted the key, nothing happened - no error messages nor confirmation message. She emailed me. I checked Google logs but could find her submission. I have to input the key for her. I am glad to receive her reply today that the greeting popup sidebar has stopped.
ReplyDeleteIf you have multiple to-do lists with same owner email, the mid-night auto-refresh on offline captured updates may not work. The issue has been resolved. User needs to run the plug in from the menu to get the update.
ReplyDeleteOn To-do List Plugin menu, I added a new function 'Contact developer' . You can use it to message me.
ReplyDeleteFor user who does not have an existing to-do list, user can run the 'Plug in' to an empty sheet. Plug-in will provide a sample for test run.
ReplyDelete