If you already manage your to-do list in Google Sheets, this plugin can help you automate and streamline it. If you don't have a to-do list yet, you can use our built-in template or simply open a blank sheet — the plugin will generate a customizable template for you.
What the Plugin Does?
The To-do List Plugin enhances your Google Sheet with smart automation:
- Customizable sorting options
- Moves completed tasks to the end of the list or to another log tab.
- Automatically inserts a blank row when the list is filled
- Deletes a row when the task description is removed
- Advances the date for repeating tasks when marked complete
- Keeps month-end tasks at the month-end upon repeat
How to install?
- Open the To-do List Plugin setup for different options of installation.
- From the Extensions menu, choose To-do List Plugin > Plug in.
How to use?
Just edit your to-do list normally. The plugin uses the onEdit trigger to automate actions based on your input:
- Editing a date: The task is re-sorted by date.
- Marking a task complete: It moves to the end of the list.
- Entering a task in the last row: A new blank row is added.
- Completing a repeating task: The date advances based on your defined frequency.
Repeating Frequency Format
Use a format like nx, where:
- n = number,
- x = d (days), w (weeks), m (months), or y (years)
- d: daily (excluding weekends)
- 1d: daily (including weekends)
- 2w: every two weeks
For monthly (m) and yearly (y) tasks, if the date is within 3 days of month-end, the next date will also stay close to month-end.
Note on Performance
The plugin relies on Google’s onEdit trigger and cloud processing. Depending on your connection and network traffic, changes may take a few seconds to reflect. A temporary red highlight on the task header signals when the plugin is working.
If plugin actions interfere with your input, use Undo (Ctrl + Z) or Version History to revert. Over time, you’ll become familiar with how Google Sheets handles these triggers.
This add-on is free for use. If you find it helpful, please consider supporting us.
Related posts:
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