Hello,
I am trying to create the foundation for a report resembling the table below, where the milestone is extracted from each project. I have looked into activity codes, but can't work out how to bring that information up to a project level.
Table:
ProjID
ProjName
Start
Finish
Milestone
001
Proj-001
01/01/2013
01/06/2013
01/03/2013
002
Proj-002
02/02/2013
01/07/2013
01/04/2013
003
Proj-003
03/03/2013
01/08/2013
01/05/2013
004
Proj-004
04/04/2013
01/09/2013
01/06/2013
Any guidance would be appreciated.
Using P6 R8.3 Professional and Enterprise
Hi Raymund,
Thanks for your reply. The milestone in question is actually the date marking the energisation of some electrical equipment. This will then be followed by some approval and testing activities, and other project formalities, which could end up finishing some time after the energisation has happened.
I was wondering if there was a way to add a column with an 'IF...THEN' formula (i.e. IF [activity name = energisation date] THEN [copy date]) and then bring this column into the project level view.
I will investigate your suggestion but I fear it isn't going to work for me.
Regards
Mark
Mark,
I assume that the Milestone is the Project Contract Finish Date.
Set the "Must Finish By" with the Project Contract Finish Date and Show the "Must Finish By" Column Renamed to Milestone.
Regards,