Use a spreadsheet to calculate and email an alert?
 

We use a shared spreadsheet to list projects and due dates. One of the
columns contains the start date, and one contains the due date,and several
columns contain team member names, but nothing automatically alerts anyone to
which projects are at the 50% stage and require a mid-course review. (For
that matter, nothing reminds anyone to open the spreadsheet each day and look
at it! :-)

What would it take to program a spreadsheet to automatically check today's
date against all start/due dates, calculate the 50% date, compare that to
today's date, and if any projects are at the 50% stage today, generate an
email alert to each team member that it's time to do a 50% review for
projects X and Y? Or, alternatively, at least whenever anyone opens the
spreadsheet on any given day, they at least get *some* kind of alert, pop up
message, or bright highlight in the spreadsheet, etc. on any projects that
have reached the 50% stage.

Use a spreadsheet to calculate and email an alert?
 

Hi JustSomeGuy

You can use a helper column like I use here
http://www.rondebruin.nl/mail/folder3/message.htm

See example 2


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JustSomeGuy" wrote in message ...
We use a shared spreadsheet to list projects and due dates. One of the
columns contains the start date, and one contains the due date,and several
columns contain team member names, but nothing automatically alerts anyone to
which projects are at the 50% stage and require a mid-course review. (For
that matter, nothing reminds anyone to open the spreadsheet each day and look
at it! :-)

What would it take to program a spreadsheet to automatically check today's
date against all start/due dates, calculate the 50% date, compare that to
today's date, and if any projects are at the 50% stage today, generate an
email alert to each team member that it's time to do a 50% review for
projects X and Y? Or, alternatively, at least whenever anyone opens the
spreadsheet on any given day, they at least get *some* kind of alert, pop up
message, or bright highlight in the spreadsheet, etc. on any projects that
have reached the 50% stage.