Category Archives: Microsoft Project

SharePoint Tasks List plus Project – Better Together

SharePoint tasks lists provide a great way to collaborate and stay up to date on the status of your projects. By using Microsoft Project Professional, you can take your project management to the next level by using more advanced features like scheduling and even create gorgeous and comprehensive reports. In a way, the SharePoint site and its tasks lists are where team members can view and edit the progress of their tasks, and Project Professional is where project managers can manage the progress of their projects. SharePoint tasks list sync empowers you to use the great functionalities of both Project and SharePoint tasks lists, at the same time.

You can create a new SharePoint tasks list that supports tasks with hierarchy, and indent/outdent those tasks while typing them in SharePoint, using the Alt+shift+Right/Left shortcuts. Then, in order to sync this SharePoint tasks list with Project, all you need to do is select the “Open with Project” button in the List tab of the ribbon:


This will open your tasks list along with the timeline view in Project Professional and you’ll even be started in a screen that walks you through 3 steps to show you how you can take advantage of the powerful features of Project:


And when you switch to the Gantt view, you can see the same tasks list as was in SharePoint:


You can continue editing the project plan in Project, and when you hit Save, Project will automatically sync the plan with the SharePoint tasks list, and also save the project file (.mpp) in the Site Assets library of the SharePoint site. Therefore, every time you, or any other project manager, open the project plan, you can view the most recent status of the project. In 2013, we are saving an up to date project file in the Site Assets library so that users won’t have to deal with multiple conflicting or out-of-date project files. Moreover, we have greatly improved the conflict resolution mechanism so we now look for conflicts at the cell-level instead of the task-level.

Accessing and re-opening this project is very easy: if you are in the SharePoint site, you can open the same project plan by selecting the “Open with Project” button. Alternatively, if you already have Project Professional open, you can find this project in the Recent Projects list in the Open tab:


Using the SharePoint tasks list feature, you can also convert standalone project plans into SharePoint tasks list and start collaborating with other team members on those plans. For instance, if you are using Project Professional to manage a special launch event, you can now go to the Save As tab of the File menu and create a new project site with an associated SharePoint tasks list:


This will create a new Project Site and save the project plan in the Site Assets library of that site. From that point on, you can open this this project plan from the tasks list and keep the tasks list and the project plan in sync.

During the SharePoint tasks list sync, we sync the following fields between your SharePoint list and Project by default: task name, start date, finish (due) date, % Complete, resource name, and predecessors. However, if you want to map more fields to be synced between Project and SharePoint, you can do so in the Info tab of the File menu: open the “Map Fields” dialog, and pick any new fields that you’d like to sync. This way, you can have your team members report on other custom fields, or generate reports based on non-default SharePoint columns.


Ref : Office Blogs

Sync Project with a SharePoint tasks list

Project can sync a list of tasks with SharePoint – without using Project Web App. Your team members can view the schedule and update their work in SharePoint, and you’ll see the change’s in Project. And vice-versa

Sync with a new SharePoint site

These steps assume you have a project open in Project, but you haven’t made a SharePoint site for it yet.

  1. In Project, click File > Save.
  2. In the Sync with list, select New SharePoint Site.
  3. In the Project name box, type a name.
  4. In the Site Address list, add the address of the SharePoint tasks list that you will sync to.
    Don’t use an address that contains the name of the Tasks List. Project ads that part automatically.ZA102830693
  5. Click Save.

Here’s what will happen: When you click Save, a new SharePoint site is created for the project. Changes you make to tasks in Project are reflected in SharePoint, and vice-versa.

Sync with an existing SharePoint site.

These steps assume you have a blank schedule open in Project, but all the tasks you want to sync to are on a SharePoint site somewhere.

  1. In Project, click File > Save.
  2. In the Sync with list, select Existing SharePoint Site.
  3. In the Site Address box, type the address of the SharePoint tasks list that you want to import.
     NOTE    Don’t use an address that contains the name of the Tasks List. Project adds that part automatically.
  4. Click Verify Site.
  5. In the Tasks List box, type or select a name for the tasks list that you want to sync with your project.ZA102830282
  6. Click Save.

When you click Save, the tasks list in SharePoint will now appear in Project. Changes you make to the list of tasks in Project will be reflected in SharePoint, and vice versa.

Ref : Microsoft Office