% complete manipulation

Joseph Tuccillo

Is it possible to have a second % complete column that somewho only shows what % of work for child tasks that have a start date that is <= Today. So basically I want to know what % of work is complete that should have already started. I would only use this formula on the top level parent row of the whole project and it would more be some additonal info that I would use in another formula but I want to figure out this calculation. Any ideas?

J. Craig Williams

Joseph,

 

=IF([Start Date]23 <= TODAY(), [% Complete]23)

 

for row 23

Blank for future items.

 

Hope this helps

Craig

Joseph Tuccillo

Thanks Craig. I think I have something that will work now. A bit more complex but basically what you just said.