MS Project Status Guidance

%3CLINGO-SUB%20id%3D%22lingo-sub-2748532%22%20slang%3D%22en-US%22%3EMS%20Project%20Status%20Guidance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748532%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Expert%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWonder%20if%20someone%20could%20assist%20%2Cme%20with%20something%20or%20perhaps%20point%20us%20in%20the%20right%20direction%20please%3F%3C%2FP%3E%3CP%3EI'm%20currently%20working%20on%20a%20Milestone%20Plan%20for%20reporting%20project%20work.%20I%E2%80%99ve%20built%20a%20project%20plan%20using%20MS%20project%20but%20I'm%20struggling%20with%20the%20logic%20to%20align%20the%20%25%20complete%20to%20the%20status%20of%20the%20task.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20an%20example%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201st%20April%202021%3C%2FP%3E%3CP%3ETarget%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2031st%20July%202021%3C%2FP%3E%3CP%3EActual%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20not%20yet%20complete%3C%2FP%3E%3CP%3EProgress%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2080%25%3C%2FP%3E%3CP%3ETask%20Status%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CSTRONG%3EOn%20Schedule%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201st%20April%202021%3C%2FP%3E%3CP%3ETarget%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2031st%20July%202021%3C%2FP%3E%3CP%3EActual%20Finish%20Date%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B12th%20August%202021%3C%2FP%3E%3CP%3EProgress%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20100%25%3C%2FP%3E%3CP%3ETask%20Status%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CSTRONG%3ELate%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201st%20April%202021%3C%2FP%3E%3CP%3ETarget%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2031st%20July%202021%3C%2FP%3E%3CP%3EActual%20Finish%20Date%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B15th%20July%202021%3C%2FP%3E%3CP%3EProgress%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20100%25%3C%2FP%3E%3CP%3ETask%20Status%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CSTRONG%3EEarly%20Complete%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201st%20April%202021%3C%2FP%3E%3CP%3ETarget%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2031st%20October%26nbsp%3B%202021%3C%2FP%3E%3CP%3EActual%20Finish%20Date%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20not%20yet%20complete%3C%2FP%3E%3CP%3EProgress%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2060%25%3C%2FP%3E%3CP%3ETask%20Status%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3EFuture%20Task%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201st%20April%202021%3C%2FP%3E%3CP%3ETarget%20Finish%20Date%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2031st%20October%26nbsp%3B%202021%3C%2FP%3E%3CP%3EActual%20Finish%20Date%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2031st%20July%202021%3C%2FP%3E%3CP%3EProgress%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20100%25%3C%2FP%3E%3CP%3ETask%20Status%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3EComplete%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ETask%20Status%3A%20On%20Schedule%2C%20Early%20Complete%2CLate%2C%20Future%20Task%2C%20Complete%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhilst%20we%E2%80%99ve%20completed%2080%25%20of%20the%20task%20it%E2%80%99s%20still%20late%20but%20our%20plan%20isn%E2%80%99t%20reflecting%20this.%20Similarly%2C%20if%20we%20reduce%20the%20progress%20to%20say%2025%25%20it%20shows%20as%26nbsp%3B%20late%20but%20doesn%E2%80%99t%20give%20an%20accurate%20reflection%20of%20the%20progress%20made.%20I%E2%80%99d%20also%20like%20to%20report%20on%20completed%20tasks%20in%20terms%20of%20what%20was%20delivered%20early%2Fon%20time%2Flate%20but%20we%E2%80%99re%20struggling%20to%20get%20this%20in%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyone%20who%20could%20help%20me%3F%3CBR%20%2F%3EMany%20Thanks%3CBR%20%2F%3EDhan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748879%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Project%20Status%20Guidance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748879%22%20slang%3D%22en-US%22%3EDhan%20--%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20value%20in%20the%20Task%20Status%20field%20is%20calculated%20by%20Microsoft%20Project%20based%20on%20the%20Status%20date%20of%20your%20project.%20The%20Status%20date%20is%20a%20value%20you%20must%20manually%20enter%2C%20and%20it%20is%20not%20generated%20for%20your%20automatically.%20The%20Status%20date%20should%20be%20the%20last%20day%20of%20the%20previous%20reporting%20period.%20So%2C%20if%20today%20is%20Tuesday%2C%20your%20Status%20date%20should%20be%20last%20Friday.%20To%20set%20the%20Status%20date%2C%20click%20the%20Project%20tab%20to%20display%20the%20Project%20ribbon%20and%20then%20click%20the%20Status%20Date%20button.%20In%20the%20Status%20Date%20dialog%2C%20enter%20the%20date%20of%20the%20last%20day%20of%20the%20previous%20reporting%20period%20and%20then%20click%20the%20OK%20button.%20You%20will%20need%20to%20do%20this%20every%20week%20to%20get%20accurate%20values%20in%20the%20Task%20Status%20field.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20do%20not%20set%20the%20Status%20date%20for%20your%20project%2C%20then%20Microsoft%20Project%20uses%20the%20Current%20Date%20value%20instead.%20I%20suspect%20that%20is%20probably%20why%20you%20are%20seeing%20unpredictable%20results%20in%20the%20Task%20Status%20field%20in%20your%20project.%20Hope%20this%20helps.%3C%2FLINGO-BODY%3E
New Contributor

Hi Expert,

 

Wonder if someone could assist ,me with something or perhaps point us in the right direction please?

I'm currently working on a Milestone Plan for reporting project work. I’ve built a project plan using MS project but I'm struggling with the logic to align the % complete to the status of the task.

 

Using an example below:

 

Start Date                1st April 2021

Target Finish Date           31st July 2021

Actual Finish Date           not yet complete

Progress                            80%

Task Status                       On Schedule

 

Start Date                1st April 2021

Target Finish Date           31st July 2021

Actual Finish Date           12th August 2021

Progress                            100%

Task Status                       Late

 

Start Date                1st April 2021

Target Finish Date           31st July 2021

Actual Finish Date           15th July 2021

Progress                            100%

Task Status                       Early Complete

 

Start Date                1st April 2021

Target Finish Date           31st October  2021

Actual Finish Date          not yet complete

Progress                            60%

Task Status                       Future Task

 

Start Date                1st April 2021

Target Finish Date           31st October  2021

Actual Finish Date          31st July 2021

Progress                            100%

Task Status                       Complete

Task Status: On Schedule, Early Complete,Late, Future Task, Complete

 

Whilst we’ve completed 80% of the task it’s still late but our plan isn’t reflecting this. Similarly, if we reduce the progress to say 25% it shows as  late but doesn’t give an accurate reflection of the progress made. I’d also like to report on completed tasks in terms of what was delivered early/on time/late but we’re struggling to get this in place.

 

Is there anyone who could help me?
Many Thanks
Dhan

1 Reply
Dhan --

The value in the Task Status field is calculated by Microsoft Project based on the Status date of your project. The Status date is a value you must manually enter, and it is not generated for your automatically. The Status date should be the last day of the previous reporting period. So, if today is Tuesday, your Status date should be last Friday. To set the Status date, click the Project tab to display the Project ribbon and then click the Status Date button. In the Status Date dialog, enter the date of the last day of the previous reporting period and then click the OK button. You will need to do this every week to get accurate values in the Task Status field.

If you do not set the Status date for your project, then Microsoft Project uses the Current Date value instead. I suspect that is probably why you are seeing unpredictable results in the Task Status field in your project. Hope this helps.