This can be achieved with a SharePoint Issue Tracker List, in which you
would capture Task, Month, Team Member etc. as metadata each time you
update a new task. We’ve used Issue Tracking List in SharePoint 2007 &
2010 to track Records Requests (much like IT Ticket Tracking software) and
run periodically reports out of the list by exporting it to an excel
spreadsheet and running pivot table/pivot chart off the data. I’ve found
using SharePoint to track performance metrics not only creates a more
transparent environment for service requests/tasks assigned to our
department, it also reduces reporting time and at the same time allows our
employees to submit requests online. We also publish our reports in
SharePoint to a small number of target audiences including our management,
instead of emailing them as attachments. I will be happy to discuss it
Records Technology Advisor
Records and Information
Plains Exploration & Production Company
[log in to unmask]
On Tue, Mar 6, 2012 at 6:40 PM, sasha babin <[log in to unmask]> wrote:
> Hello to Fellows,
> Does somebody know how to create in Sharepoint something that was "easy"
> in Excel:
> Before we used to do our Monthly Stats in Excel - Rows for task, columns
> for months, sheet for team member.
> Now management wants to do the same in Sharepoint, or to use Sharepoint
> instead Excel.
> Could somebody shares with experience of using Sharepoint instead Excel
> spreadsheets, or it is simply misunderstanding what Sharepoint has been
> created for?
> Alex Babin
> [log in to unmask]
> List archives at http://lists.ufl.edu/archives/recmgmt-l.html
> Contact [log in to unmask] for assistance
> To unsubscribe from this list, click the below link. If not already
> present, place UNSUBSCRIBE RECMGMT-L or UNSUB RECMGMT-L in the body of the
> mailto:[log in to unmask]
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
To unsubscribe from this list, click the below link. If not already present, place UNSUBSCRIBE RECMGMT-L or UNSUB RECMGMT-L in the body of the message.
mailto:[log in to unmask]