simple Task management in Google Sheets
Started by jaslar
on 4/20/2020
jaslar
4/20/2020 5:31 pm
The Next Web: Holy sheet: How to create a simple to-do list with Google Sheets.
https://thenextweb.com/basics/2020/04/20/holy-sheet-simple-to-do-list-google-sheets/
Way too simple for this crowd, and God forbid we should use something we already have. But I didn't know about the check box option.
https://thenextweb.com/basics/2020/04/20/holy-sheet-simple-to-do-list-google-sheets/
Way too simple for this crowd, and God forbid we should use something we already have. But I didn't know about the check box option.
Franz Grieser
4/20/2020 9:01 pm
jaslar wrote:
LOL.
I've been keeping my todo list in an XLS file (first in OpenOffice Calc, now in Planmaker from Softmaker Office Pro) since 2014. Instead of Google Sheets' checkboxes I use "X".
It's a simple list with columns for my different jobs and for private tasks. And at the same time an archive of all my todos and dones from the last 6 years.
The Next Web: Holy sheet: How to create a simple to-do list with Google
Sheets.
https://thenextweb.com/basics/2020/04/20/holy-sheet-simple-to-do-list-google-sheets/
Way too simple for this crowd, and God forbid we should use something we
already have. But I didn't know about the check box option.
LOL.
I've been keeping my todo list in an XLS file (first in OpenOffice Calc, now in Planmaker from Softmaker Office Pro) since 2014. Instead of Google Sheets' checkboxes I use "X".
It's a simple list with columns for my different jobs and for private tasks. And at the same time an archive of all my todos and dones from the last 6 years.
Arnold
4/21/2020 12:49 am
The use of a spreadsheet for GTD has been around a long time.
http://gtd.marvelz.com/blog/2007/01/01/implementing-gtd-with-excel/
It is perfectly possible to implement GTD in Excel. In fact, I think Excel is a perfect tool for many purposes. Using a combination of built-in Excel formulas and my own custom made VBA code, I have implemented a basic GTD system for myself. It is in fact an ongoing project, but I am using the system successfully every day.
Can be rather detailed or very simple depends on the person of course.
http://gtd.marvelz.com/blog/2007/01/01/implementing-gtd-with-excel/
It is perfectly possible to implement GTD in Excel. In fact, I think Excel is a perfect tool for many purposes. Using a combination of built-in Excel formulas and my own custom made VBA code, I have implemented a basic GTD system for myself. It is in fact an ongoing project, but I am using the system successfully every day.
Can be rather detailed or very simple depends on the person of course.
jaslar
4/21/2020 3:53 am
Right, and Excel allows you to fold. I don't know if Sheets does or not.
MadaboutDana
4/21/2020 1:07 pm
Numbers also allows you to fold - although it can be a bit complicated to set up.
Andy Brice
4/21/2020 4:50 pm
Excel is the main competitor to just about every software product I have ever written, including Hyper Plan.
jaslar
4/22/2020 2:48 am
I see your point. After I studied the first link I sent about using Excel, I see that it was actually pretty sophisticated. Then I poked around with Google Sheets, which also has checkboxes and grouping (the spreadsheet word for folding). LibreOffice Calc does not have grouping, which is interesting.
Years ago, I designed a pretty robust task management system using the Appleworks database module, a sort of pared down File Maker Pro. Spreadsheets can provide a lot of the same functionality. But I have to say that something like AirTable is easier to use than Excel.
Years ago, I designed a pretty robust task management system using the Appleworks database module, a sort of pared down File Maker Pro. Spreadsheets can provide a lot of the same functionality. But I have to say that something like AirTable is easier to use than Excel.
Hugh
4/22/2020 7:54 am
Andy Brice wrote:
Excel is the main competitor to just about every software product I have
ever written, including Hyper Plan.
Excel is a wonderful programme. Too huge for some, yes, ungainly sometimes, less nifty than Numbers, but still wonderful. Working mostly in sentences not calculations, I wouldn't - you might think - have much use for it. But I do. Leaving aside the more familiar terrain of personal financial records and planning, for a time I outlined longform pieces in Excel, factual and fictional, listed locations and characters, even crudely timelined. I still keep records in Excel of versions, word counts, page revisions and work durations, and roughly calculate productivity.
I think I read somewhere that someone had managed to write a novel in Excel, but I never managed to track the source of that report down.
Andy Brice
4/22/2020 8:05 am
Excel is a very impressive piece of software. You can do just about anything in Excel, even create art:
https://mymodernmet.com/excel-art/
It is not necessarily the best tool for the job though. ;0)
https://mymodernmet.com/excel-art/
It is not necessarily the best tool for the job though. ;0)
mseliger
4/22/2020 10:04 am
jaslar wrote:
LibreOffice Calc does not have grouping, which is interesting.
LibreOffice Calc has also a grouping feature at least in version 6.4.0.3 (but perhaps also in former versions) (Menu Data | Group and Outline).
Lb
4/22/2020 12:38 pm
This reminded me of when I used to keep a simple to do list and pretty much a whole PIM of information in spreadsheets back in the late 80's and early 90's. Sidekick was fun but didn't do it all for me.
I used Lucid-3D at first. Having sheets for the to-do, contacts, calendar events, notes etc. There wasn't too much need for passwords back then unless you got on Compuserve. It was just about all BBS's.
Then I started on Quattro Pro and became pretty good with macros in it. I even created a whole inventory / ordering system for a warehouse I worked for. I'm not good at programming it's just that spreadsheets are so versatile.
Spreadsheets are incredible. Thinking of it, I can't believe I haven't used one for years.
Now I'm going to go start to play in spreadsheets again. Thanks for the reminder everyone.
Larry
I used Lucid-3D at first. Having sheets for the to-do, contacts, calendar events, notes etc. There wasn't too much need for passwords back then unless you got on Compuserve. It was just about all BBS's.
Then I started on Quattro Pro and became pretty good with macros in it. I even created a whole inventory / ordering system for a warehouse I worked for. I'm not good at programming it's just that spreadsheets are so versatile.
Spreadsheets are incredible. Thinking of it, I can't believe I haven't used one for years.
Now I'm going to go start to play in spreadsheets again. Thanks for the reminder everyone.
Larry
Hugh
4/22/2020 2:23 pm
Now, if only Excel or Google Sheets could monitor my web browser and alert me when my local supermarket opens up new delivery slots for self-isolators like me...
