|
| View All Microsoft Sharepoint General Posts Ask A New Question |
|
Tracking Project Status |
H posted on Monday, January 29, 2007 8:20 AM
|
Hello,
I have an excel spreadsheet which has serveral columns. The columns include
the following (project name, % complete, estimated hours, hours used to
date, date started, status details, etc.). With this spreadsheet, I am using
over 20 columns to keep track of the data.
I need to use SharePoint to keep track of the status of several projects.
Could you tell me the best way to use SharePoint to do this? I heard that you
could create a list to do this however i have several columns that are needed
so i'm looking for an efficient solution to my problem.
Thanks. |
 |
|
| |
|
|
the answer will depend on which version of WSS you are using. |
Dean posted on Monday, January 29, 2007 11:22 AM
|
the answer will depend on which version of WSS you are using. There is
built-in Task list that is intended to do exactly what you want, some of the
limitations in WSS 2 have been removed in WSS 3. You could add additional
columns to the Task list and then copy/paste your data from Excel, (the
columns will need to be arranged in the correct sequence and the data types
in your SharePoint list must be the same as the columns in Excel)
You can also use the Publish List feature in Excel to create a new custom
list in a WSS site that contains the exact same columns as your excel
worksheet. To do this, select your range, convert to List, publish list to
an existing WSS site-details in the Excel Help. |
 |
|
|
|
|
| Previous Microsoft Sharepoint General conversation. |