Skip to Content

Tag Archives: Formula

Webinar Recap: Best Practices for Making Use of Formulas in Microsoft Project

Posted: April 17, 2019 Presenter: Safford Black [SB] Moderator: Kyle [Kyle]   Please find below a transcription of the audio portion of Safford Black’s Best Practices for Making Use of Formulas in Microsoft Project webinar being provided by MPUG for the convenience of our members. You may wish to use this transcript for the purposes…

Best Practices for Making Use of Formulas in Microsoft Project

  Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDUs in the Technical category of the Talent Triangle.   Event Description: Take your Microsoft Project plans to the next level by learning how to use formulas to compute key project information. Learn when a formula will work and…

MS Project Formula Tips

Microsoft Project formulae are a powerful way to introduce custom calculations into your project plan. Many people who may be familiar with writing formulas in Excel find Microsoft Project’s formula editor a little less intuitive, so this article will give you a basic introduction to formulas in MS Project. I hope you can get started…

The Magic Formula and Manual Work Assignment

We all know that the heart of MS Project is the “magic” formula: Work = Duration * Units. This formula works with automatically scheduled tasks, but does it always work? Let me illustrate my point by creating a simple project with two tasks: As you can see, Work is 0 hours, because there are no…

Smart Numbering Master Schedule Tasks

In a Consolidated Schedule, volatile IDs will show repeated numbers representing a task’s ID in a subproject.  This creates confusion and it is difficult to search a task by ID.  Therefore, when using a Consolidated Schedule (Master Schedule)[1], you need to differentiate one project from another.  One way to do this is to use a…

Webinar: Project Talk – Formulas in Project and Project Server

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical Category of the Talent Triangle. Event Description: You have decided to put calculations into Microsoft Project or Project Server? Sounds simple! So join us on Project Talk with your ideas and questions. Learn the steps needed…

Webinar: Tips, Tricks, and Best Practices for Using Microsoft Project

Please log in above or start a free trial to view this video   Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1.5 PMI® PDU in the Technical Category of the Talent Triangle. Event Description:  Looking for ways to make your projects more efficient, wow your co-workers, and learn some…

Project Date Numbering

Often a schedule is prepared without knowledge of an actual start date. For example, a proposal may be prepared and shown to a customer who wants to know what happens on each day of the project without regard to a calendar date. This article shows how to present a schedule using “Project Days” instead of…

An Update Status Indicator for Microsoft Project

A simple but effective “Update Status Indicator” can be generated using the excellent Custom Fields features available in Microsoft Project 2000 and later versions. When you need to revise a large project plan, how do you identify those tasks that need updating? By constructing the custom field I describe below, you’ll get red, blue and…

Please enter your email to continue viewing