Short answer: Use a free Google Apps Script that adds a Tools menu next to File and Edit: sort a task list by due date, highlight what's overdue and clear finished rows, in one click. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Set up the Tasks tab; Paste the script; Use the menu; Add a button; Make it yours.
How to set it up
- Set up the Tasks tab. Make a tab called Tasks with three columns: the task, a due date and a status.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below. The onOpen function builds the menu every time the sheet loads. Save, reload the sheet, and the Tools menu is there.
- Use the menu. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once. Then Sort by due date orders the list, Highlight overdue turns late tasks red, and Clear done rows removes finished work.
- Add a button. Want a button instead? Insert a drawing, label it, click its three dots, choose Assign script and type the function name, such as
highlightOverdue. Anyone on your team can then run it with one click. - Make it yours. Swap in your own actions: each menu item calls one function by name.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that adds a Tools menu next to File and Edit: sort a task list by due date, highlight what's overdue and clear finished rows, in one click.
How do I set it up?
In 5 steps: 1. Set up the Tasks tab; 2. Paste the script; 3. Use the menu; 4. Add a button; 5. Make it yours. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/