August 13, 2012
We will be importing an Excel spreadsheet, which will contain a simple list of Projects being run and will contain the following information: Project ID, Name, Project type, Project owner name, Current status, and then subsequent dates for various tasks to be completed for that project.
What I want is to colour code the dates based on a traffic light system, and set up a rule to enable SharePoint to send a report of programs that contain RED and AMBER dates (i.e. those requiring action etc) on a weekly basis.
Can this be set up within Sharepoint Alerts? And can more that one Alert be set up? (i.e. also a monthly report of outstanding RED, AMBERS, and a monthly report of GREEN completed tasks).
Preferrably without any coding being deployed please.
Most Users Ever Online: 91
Currently Browsing this Page:
Guest Posters: 877
Administrators: Learning SharePoint (223)