Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 01-10-2016, 06:27 PM
JulieS JulieS is offline How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Windows 7 64bit How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Please do not post the same question to multiple forums. Please continue to work with John.

https://social.technet.microsoft.com...nal2010general
Reply With Quote
  #3  
Old 01-10-2016, 06:35 PM
AK04 AK04 is offline How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Windows 7 64bit How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010 Office 2013
Novice
How to show the overdue, Late, Onschedule &amp; Completed tasks using MSP 2010
 
Join Date: Jan 2016
Location: Melbourne
Posts: 2
AK04 is on a distinguished road
Default

Quote:
Originally Posted by JulieS View Post
Please do not post the same question to multiple forums. Please continue to work with John.

https://social.technet.microsoft.com...nal2010general
Sure Thanks.
Reply With Quote
Reply



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 07:50 AM.


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