How I use spreadsheets to manage all my todos in one place
Recently, though, I have settled on a new way of managing all my todos in one tool: a spreadsheet. I did this for a number of reasons:
1. It was not easy integrating any one tool with all the others.
2. I need to maintain different formats, depending on who I am working for.
3. I need an easy way to focus on specific todos
I found a spreadsheet let me do all those things. Here’s how.
This is a typical worksheet in my todolist spreadsheet. (I keep a separate worksheet for each week.)
- Column A is the priority of the task.
- Column B is an arbitrary flag I use.
- Column C is a category tag. I have three categories of todos: Home, Proj(ect), and Admin. (Column B and C work together. For example, I can group all my Home related activities related to my kids by putting “Kids” in column B.).
- Column D I will explain later.
- Column E is the actual task itself
- Column F is the day the task will be worked on and completed.
- Column G is the tasks status. I have three: Complete, working on it (WIP = work in progress) or Pending (not yet working on it).
- Column H is for free form comments.
Next, each column has a filter on it, so I can drill down on specific items. For example, here are all the todos I have listed concerning my current work project.
I can drill down on more than one column. For example, I could set the filters for all priority 1, project related todos that are due on the day of “F” (Friday) that are “Pending”. Or I could see all Home todos that are priority 1 that are not complete by setting a custom filter where the status field is not “Complete”. There are all sorts of ways of slicing and dicing the todo list, but what I end up with is one complete todo list, not a bunch of separate ones to manage.
Not only can I filter out specific todos, but I can filter out whole columns by hiding them. Here is the list of project related todos with just three fields.
Why? Well, for my status report, I need to fill in this table in a Word document, like this:
To fill that out, I just need to copy and paste.
I can also copy and paste into my other tools that I use, too. For example, here is the same three items put into a wiki, in this case, TiddlyWiki
Column D of the spreadsheet is used for the wiki’s markup language, in this case, an asterisk. I copied columns D and E right into the wiki and the wiki formatted it for me.
I then took column E and pasted it into Workflowy, like this:
That way I can look up the list easily via my old Blackberry, my Netbook, or my iPod touch.
I could also email the todolist to RememberTheMilk.com and have my todos updated there, also. Or I could store the spreadsheet in Zoho.com and access it there as well, though I think there filter support is limited.
Regardless, as you can see, I can do alot with this one spreadsheet. I can capture and update all my todos in one list, then copy them into other tools as I need to with little effort. I am sure people who are much better with these tools than I am could think of even better ways to go about doing this.
I hope you find this helpful.