Forum Discussion

Brass Contributor

Jan 08, 2021

calculating how far behind a task is

I use the project status date and progress lines a lot to visually inspect a plan to quickly identify tasks which are tracking behind or ahead of where they "should be" based on the expected level of...

Miles_Goodchild

Brass Contributor

Jan 08, 2021

Dale_HowardMVP Thank you for the suggestion which is a powerful approach which can be very useful. One weakness that this has is that if the team feels that despite the progress to date they can pull the time back and protect the end date this method doesn't allow for this. Obviously this doesn't apply in the example you gave; rather the team member would need to give a new finish date 🙂

Your comment on Baselines raises a smile 🙂

I have a nasty feeling that project will not be able to perform the calculation I want however I am hoping that someone can prove this incorrect.

Thanks

Miles

Dale_HowardMVP

MVP

Jan 08, 2021

Miles_Goodchild -- There is no direct method in Microsoft Project to compare the expected % complete progress with the actual % complete progress. The only way to do that is to use the EVA tables in the software. However, I doubt your team would find the EVA information to be of any value to them.

Unless someone a whole lot smarter than me knows how to create the formula you seek, then I think you might want to reconsider the advice I gave in my previous post. Sorry, but hope this helps.