View Single Post
 
Old 01-10-2016, 05:56 PM
AK04 AK04 is offline Windows 7 64bit Office 2013
Novice
 
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