Automated task status in a project plan

mmurphy14986

I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task.  I've tried several of the IF OR and IFAND statements and they work partly.  I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress".  When I try to nest the "In Progress" I get an error message.  Here is the logic I would like to use:

If % Complete equals 0, “Not Started”, or if % Complete equals 100, “Complete”, or if % Complete < 100 and > 0, “In Progress”

Any suggestions??

 

Mike Wilday

Try this formula. It should work for you. It will give you the result of "Not Started" if the % complete column is blank or has a 0. And then will give you the result of Complete if the % Complete is 100% which is really the number 1 in columns that are styled with the percent icon from the left menu. And then if any other value is in the field it will say in progress. 

=IF(OR([% Complete]6 = 0, ISBLANK([% Complete]6)), "Not Started", IF([% Complete]6 = 1, "Complete", "In Progress"))

Hope that helps!