To Do List - Creating one in Excel

[damian_r]

Hi folks,

Has anyone ever tried creating a 'To Do Remider List' using Excel, using such fields as Projects, Date added, date due, level of importance etc etc etc

Does anyone have any ideas as to what they might want on such a list as once i've created mine I'll freely give it out ot others (even though it'll be a VERy basic spreadsheet)


Damian

 

[nbrcrunch]

Yes, Damien, this is a very common use of Excel. In my version I use logical indicators to yellow-highlight the next recurring event. Because of the extended criteria, Outlook was not a good answer so I used Excel to create this.

 

[damian_r]

Hmm, sounds interesting!

. . . . but i must ask, what do you mean by logical indicators?


Any chance of a screen shot of what yours looks like?


Damian

 

[damian_r]

Taking my thoughts further, is the following possible and how would you go about doing it.

1) Have a button, that when clicked on would automatically bring up a pop up box which wold have cells that you filled in which 'copied' the various contents to the corresponding cells in the to do list.

2) have the list continually autofilter based on teh contents of a certain column, such as level of importance ie, VH, H, M, L, VL


Damian

 

[damian_r]

. . . . . Anyone willing to give examples of their spreadsheets and the trickery thay have made it do?


D

 

[nbrcrunch]

Screen shots require an external website.

By logical indicators I mean that each task's highlight on/off is controlled by as little as one or as many as 7 different logic indicators. For example, one particular task is monthly on the second to the last wednesday of the month unless the upcoming 25th of the month falls on the weekend. If so, then the task is done two days earlier.

So in one column I have logic that turns TRUE/FALSE depending on if the 25 occurs on the weekend, in another column I have logic that checks the date, and finally in another column I have other logic. All of these resolve to TRUE/FALSE. Last, in the "master" logic column, If all the other pieces are TRUE, the master turns to TRUE. Conditional formatting reads the Master value TRUE (for the record/row) and turns on the highlighting.