Automate your Google sheet to-do list 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 later.
Informações atualizadas:1 de junho de 2024
Compatível com:
4 mil+
Visão geral
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?

1. Open your existing to-do list Google sheet or a blank Google sheet. 
2. 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.
3. 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?

1. You just edit your to-do list. 
2. 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 plugin is free for installation and use. If it saves your time, please support me.

#SPCsoft #to-do #todo #todolist
Informações adicionais
PreçosSem custo financeiro
Desenvolvedor
Não empreendedor
Política de Privacidade
Termos de Serviço
O To-do List Plugin pedirá as permissões abaixo. Saiba mais
O To-do List Plugin precisará de acesso à sua Conta do Google
Isso permite que o To-do List Plugin faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Permitir que este aplicativo seja executado quando você não estiver presente
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Comentários
Idioma:
Ordenar por:
O Google não verifica avaliações nem classificações. Saiba mais sobre as avaliações
Nenhum comentário
Pesquisa
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal