Why has a task disappeared from my Timesheet?

Posted By Posted by: Cheston Hsu on May 17, 2019

Timesheets are important for projects as they are often the source-of-truth for effort consumed. They form the basis of many project cost reports. This blog aims to explain the somewhat mysterious behaviour of Microsoft Project Online (and also Project Server 2010, 2013, 2016, 2019) timesheet module that timesheet users and managers interact with. One of

Read More


Blog Posted In 

Update Project Online Resource Custom Field with Lookup Value Using PowerShell

Posted By Posted by: Ahmed Taee on April 29, 2019

Preface There are plenty of useful blogs that discuss how to update custom fields using PowerShell (or .Net) in Project Online/Project Server 2013 or later, but most don’t discuss how to update custom fields which utilize a lookup table. As it turns out, this is rather tricky. Objective To update a custom field that utilizes

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Bulk Publish Enterprise Projects Using Microsoft Project Desktop Client

Posted By Posted by: Peter Williams on April 2, 2019

There is all too often a need to bulk publish all enterprise projects. For example, a project custom field formula, or perhaps a lookup value, has been modified; that change won’t appear in reports correctly until all the projects are published. Performing the bulk publish can be achieved by utilizing a small custom PowerShell script

Read More


Blog Posted In 

Retrieving the Status Manager via OData with Project Online

Posted By Posted by: Ahmed Taee on March 27, 2019

Objectives: To return the status manager information using OData Task tables. Definition: The Status Manager field in Microsoft Project contains the name of the enterprise user who is to receive status updates for the current task from resources submitting timesheets/status updates. By default, the status manager is the user who created the task. The status

Read More


Blog Posted In 

Microsoft Project Online: What licenses do I need?

Posted By Posted by: Dan Stopher on March 8, 2019

There have been many times I’ve been asked about what Project Online license was required for a particular function and struggled to provide a solid answer based on the information available on Microsoft Project Online licenses comparison table here. At a high level, the information on the comparison table is useful. But when faced with

Read More


Blog Posted In Blog Posted In: Blog, Project Online
Blog Posted In 

Create Schedule Template with Resource Utilisation Configured to Resource Engagements

Posted By Posted by: Khurram Jamshed on February 26, 2019

When it comes to resource planning of your project, you can either take a top-down approach that happens at the start of the project. Or a bottom-up with a detailed Resource Plan being created at the project planning phase. Microsoft Project Online as a tool can be utilised to support both approaches: 1. Top-down resource

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Create a Word document automatically from Project Data using Flow

Posted By Posted by: Khurram Jamshed on February 20, 2019

Microsoft Project Online solution enables the storage of project data in a central repository to increase visibility across the organisation. Reporting on that data can be generated using different tools available such as SSRS, Power BI etc.  An example of the reporting output is a nicely formatted Word document with the most up-to-date project status

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online, Reporting
Blog Posted In 

A Pragmatic Approach to Baselines

Posted By Posted by: Dan Stopher on June 5, 2018

We know the theory – a baseline is a line that is used for measurement. In the PPM world, it frequently refers to a snapshot of the schedule at a point in time that is used to compare how you’re actually doing against the original plan. Often comparisons of your current plan with the baseline

Read More


Blog Posted In Blog Posted In: Blog, PMO, Project Online
Blog Posted In 

Using Effective From Dates for Resource Rate Increase

Posted By Posted by: Dan Stopher on May 25, 2018

Many Microsoft Project users are familiar with the ability to change resources rates from an effective date. Essentially, the Resource is edited in MS Project by double-clicking on the resource and going to the Resource Information -> Costs as shown below: MS Project handles rates update using this manner nicely. For tasks that span a

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Calculate Resource Utilisation from Resource Engagements Explained

Posted By Posted by: Dan Stopher on April 20, 2018

Since the introduction of Engagements to Microsoft Project Online we have had the below option in MS Project under Project -> Project Information But what exactly does this setting do? Resource Centre In the case of the Resource Centre -> Capacity Planning -> Capacity and Engagements heatmap view, this setting has no effect! This view shows

Read More


Blog Posted In Blog Posted In: Blog, Project Online, Reporting
Blog Posted In