Microsoft project professional 2013 not showing

#Microsoft project professional 2013 not showing how to

Then click on the Formula button, and past in the following formula, if you are using MS Project 2007 or earlier: YouвЂ™ll get a warning message thatвЂ™s fine, because you really do want to calculate the values. Under custom attributes, click on the radio button for Formula. Right click on the newly inserted column and select вЂњCustom Fields.вЂќ From here, you can rename the field (I chose вЂњStвЂќ to keep it brief). Click вЂњInsert ColumnвЂќ and then select Number 1.

To add this to your project schedule, right click on the column where you want to insert the status indicator.

Keep this in mind for later, when weвЂ™ll talk about summary tasks. If the percent complete is less than the number of days since the task was scheduled to begin, divided by the task duration, it will be Yellow otherwise, it will be Green. That вЂњprorated expected completionвЂќ is calculated using the project calendar.

Otherwise, if % Complete is = the prorated expected completion, return Green.

If the scheduled finish is at least seven days away, return Clear.

So, based on some of those comments and a request from Marlene Robertson, IвЂ™ve decided to post an update. It has since become the most widely read, referenced, and commented-on post IвЂ™ve ever made.

#Microsoft project professional 2013 not showing how to

Download the book and a sample MS Project file demonstrating the techniques shown here.ДЄbout a year ago, I posted an explanation of how to create a вЂњstop lightвЂќ status indicator using calculated fields in MS Project. An improved version of this article is included in my free e-book, MS Project Hacks.