Re: Creating to do lists
- From: houghi <houghi@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 2 Mar 2008 13:44:13 +0100
wendiilord@xxxxxxxxxxxxxx wrote:
Hello.
I need some help with creating a todo list. I work in recruitment,
and we have certain things to do after certain periods of time. For
example, I have to contact the hiring manager 2 days after a vacancy
closes, which is 14 days after it opens. I have created a spreadsheet
with all the different activities and their dependancies, and I can
put in the opening date and get a list of other dates when I need to
do something.
The problem is, I have 30+ jobs on the go at one time. What I want to
do is have excel scan all the data, then present me with a date
ordered to do list.. so I can see all the activities I should be doing
today.
Is this possible?
Yes. Others will be better with giving the actual coding then I am.
basicaly you will have three fields. 1 with the start date, one with the
current date and one with what you want to do.
=IF(ISBLANK(A1);"";IF((B1-A1)>14;"Conatct Manager";""))
A1 is the date of the opening. B1 is =TODAY()
The first part tells you to show nothing if A1 is empty. Then it won't
do anything. The second IF will show "Contact Manager" if it is longer
then 14 days.
There is one drawback and that is that you will see it even after 2000
days and that is something you do not want. The best would be to enter
an extra field where you enter wether or not you have done what is
required and use yet another if in the above to show it not anymore if
the selection with e.g. a dropdown is Yes (and where the default would
be No.
With autofilter it should then be easy to show all the non-blanks and
have those things that need something done shown. As long as you do not
change anyting, you do not need to bother about weekends and such.
houghi
--
It's people. Source code is made out of people! They're making our
source out of people. Next thing they'll be breeding us like cattle
for code. You've gotta tell them. You've gotta tell them!
.
- References:
- Creating to do lists
- From: wendiilord
- Creating to do lists
- Prev by Date: Re: Print Screen
- Next by Date: Re: Creating to do lists
- Previous by thread: Re: Creating to do lists
- Next by thread: Re: Creating to do lists
- Index(es):
Relevant Pages
|
