Calendar workflow and calculated values

We are creating a workflow in the Calendar for events. Here are thesteps:

1. Team Lead creates Event in the Calendar on CreationDate.1a. The System needs to confirm that the leadtime for the event is 6months for Category 1 events, 4 months for Category 2 events and 2months for Category 3 events ELSE the event needs special approvalbefore being entered into the Calendar, where leadtime=EventStartDate-CreationDate.

2. Once the event has been created, the workflow kicks in and sendan alert to Group 1 (consisting of 28 Department Representatives)for feedback who have to respond within CreationDate+14.2b. A reminder needs to be sent to those who don't respond withinCreationDate+7.The feedback from Group 1 will divide them into participatingGroup1A and non-participating Group1B. Group 1A and Group 1B will bedifferent for different events.3. The Team Lead then includes the participation level (1-3) of eachDepartment.3b. The Team Lead manually sends out an Acknowledgement workflow toGroup 2B consisting of Heads of non-participating Divisions.3c. The Team Lead manually sends out an Approval workflow to Group2A consisting of Heads of participating Divisions.4. On approval, the event appears in the calendar.5. After the event, the system must automatically send out areminder on EndDate to the TeamLead and Group 1A to raise a ClosureReport before EndDate+7.5a. Before EndDate+7, the TeamLead must fill field "Closure Reportsent out" as "Yes" ELSE system will send out alert to Group 2A.

Questions per numbering above:1b. Can the system check that StartDate-CreationDate falls withinthe 3 categories ELSE prevent the Event from being entered withoutspecial approval?2b. Can reminders be sent specifically to those who don't respond?Is there a calculated value for CreationDate+7?3b & 3c. Can the distribution lists for Groups 2A and 2B beautomatically generated taking into account that they are differentfor different events?5. Can system automatically send out a reminder on EndDate?5b. Can the system send out an alert to Group 2A on EndDate+7IF "ClosureReportSentOut" is not equal to "Yes"?

That's a lot of questions. Hope someone familiar with MOSS2007 canhelp. Note that I have used "the system" to denote MOSS2007.

We've found that the questions on dates can be resolved using SharepointDesigner.Now it's just:how to send reminders only to those who don't respond,somehow mark the events differently that are created below required leadtime,andhow to re-use the distribution list of an earlier workflow in the same event ina later automated workflow.

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.