Project Custom Column Assistance Request

[johnnyflet]

Hello!

I am trying to add a custom column to a master file with a number of projects already embedded. The custom column is a graphical signal indicator working off a formula - code here:

--

IIf([% Complete]=100,0,ProjDateDiff([Finish],Date(),"standard")/480)

--

When I add this to a single project, I get the desired number, but when I add it to the master file, I get a 0. I can't add even simpler custom columns either (ex - Date() ).

Any ideas? I am pulling my hair out trying to figure out why this isn't working.

Thanks!

John

 

[johnnyflet]

Whoops - working off of Project 2007 Standard.

 

[johnnyflet]

lol.. first and last thread in this forum.

 

[PDQBach]

The formula you have in your sub-project file gets imported and is not overridden by the formula you have in your master file.

So ... you have to put the same formula in each sub-project file *and* in the master project (assuming it has some summary and detail tasks of its own).