Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-10-2016, 05:56 PM
AK04 AK04 is offline How to show the overdue, Late, Onschedule & Completed tasks using MSP 2010 Windows 7 64bit How to show the overdue, Late, Onschedule & Completed tasks using MSP 2010 Office 2013
Novice
How to show the overdue, Late, Onschedule & Completed tasks using MSP 2010
 
Join Date: Jan 2016
Location: Melbourne
Posts: 2
AK04 is on a distinguished road
Default How to show the overdue, Late, Onschedule & Completed tasks using MSP 2010

Hi,



I am using this formula Switch([Finish]>[Baseline Finish] And [Baseline Finish]<[Status Date] And [% Complete]<100,"Overdue",[% Complete]=100,"Complete",[Total Slack]<0,"Late",[Total Slack]>=0,"On Schedule") in the custom field of the "Text Coulmn", but it isn't working for the Overdue tasks. It doesn't honor the "Status Date", and shows overdue for all the tasks which has paased their baseline date. Does anyone know how to show the status of the project in terms of overdue, Late, Onschedule & Completed tasks using MSP 2010.

Thanks in advance.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Project Status and Late Tasks - Incorrect BarryB Project 4 08-02-2015 01:50 PM
How to show overdue tasks? Anastasia Sudbinina Project 1 03-17-2015 08:26 AM
Filter - Late Tasks EC37 Project 3 06-12-2014 08:57 AM
How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Change font colour when tasks are completed meileetan Project 3 09-12-2012 07:09 AM
updating not completed tasks or 0% tasks ketanco Project 3 08-24-2012 05:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft