Incomplete work left to go

jacob sundermeyer

Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)?

It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. 

Is there another way to get there that I'm overlooking?

Paul Newcome

If you create a helper column [Remaining Durations], you can enter the following formula and dragfill down the column:

 

=IF([Status Column Name]@row = "Complete", Duration@row / COUNTIFS(Predecessors:Predecessors, Predecessors@row))

 

You can then use a basic =SUM([Remaining Durations]:[Remaining Durations]) to add everything up.

 

This will only look at durations for tasks that are not complete. It will look at how many times the same predecessor is found and divide the duration by that. Basically if two tasks each last for 1 day but have the same predecessors and are incomplete, it will show as 0.5 for each task. You then sum those totals up, and there you go.

 

Will this work for you?