Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-21-2021, 07:49 AM
MattMols MattMols is offline Most recent baseline of sub-projects in master project Windows 10 Most recent baseline of sub-projects in master project Office 2019
Novice
Most recent baseline of sub-projects in master project
 
Join Date: Jun 2021
Posts: 1
MattMols is on a distinguished road
Default Most recent baseline of sub-projects in master project

I have a master project with 4 sub-projects. Each sub-project is on a different baseline number (I.e. baseline2, badeline7, etc…).

Is there a way to show the start date of the most recent baseline of each sub-project in one column on the master project? As in have a baseline start date column in the master project, but it pulls the dates from the last-saved baseline of each sub-Project instead of having to have a column for baseline1 start, baseline3 start, baseline7 start, etc…
Reply With Quote
  #2  
Old 06-30-2021, 10:33 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Most recent baseline of sub-projects in master project Windows 10 Most recent baseline of sub-projects in master project Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

In each of the 4 subprojects, add a custom Start field, say Start1 and in each subproject, enter the formula

= baselineX start, where X is the last saved baseline number for that project.

E.g. If Project A last saved baseline is Baseline7, the formula for for Start1 custom field in Project A will be = Baseline7 Start

If Project B last saved baseline is Baseline2, the formula for Start1 custom field in Project B will = Baseline2 Start

Now, in the Master Project, add a Start1 column and it will display the latest saved baseline dates for each subproject in this single Start1 column.

All you need to do is remember to update the formula for each subproject anytime, you save a new baseline.

Give us a shout if you need further help with this.

==
Planners' Place
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Most recent baseline of sub-projects in master project Baseline Execution Index (BEI) in Project 365 advillanuevag Project 3 05-02-2021 12:52 PM
Master plan and sub projects MS project 2016 runejors Project 0 09-09-2019 03:34 AM
Help me about Project Pro 2010 ( How do can create Split Baseline?) huybuonvp Project 7 02-11-2014 07:49 AM
Project baseline duration Alka Project 1 11-20-2012 05:09 AM
Master Projects with different Working Days Philip.Skeet Project 2 08-19-2011 09:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft