Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-23-2015, 05:45 AM
deepsk deepsk is offline Windows XP Office 2013
Novice
 
Join Date: Apr 2015
Posts: 2
deepsk is on a distinguished road
Default RAG Status on Project 2013

Can someone help?!

Created a plan in MS Project 2013 but need the RAG status to be based on the baselined dates.



e.g.
Task will go red if new date entered is after the baselined date.
But when baselined date is updated it will go to Green
Along with the % complete making the RAG blue when it hits 100%

Is there anyway this can be done?
Reply With Quote
  #2  
Old 04-23-2015, 06:50 AM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,696
JulieS will become famous soon enough
Default

I'm afraid I don't follow completely. Are you talking about tasks with a Finish Variance where Baseline Finish < Finish? Have you considered using the built-in Status Indicator field?
Reply With Quote
  #3  
Old 04-23-2015, 06:59 AM
deepsk deepsk is offline Windows XP Office 2013
Novice
 
Join Date: Apr 2015
Posts: 2
deepsk is on a distinguished road
Default

Hi Jules,
Please see example below

Task Start End Baseline Start Baseline Finish
Testing 23/04 23/04 22/04 22/04

with the above I need the status indicator to show a Red RAG status

but when you change the baseline dates to 23/04 it will go back to green indicating the task is no longer overdue

does that help?
Reply With Quote
  #4  
Old 04-23-2015, 07:26 AM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,696
JulieS will become famous soon enough
Default

I understand, but you should not be manually editing the baseline fields. In your scenario, the task both starts and ends late as compared to the baseline data. Do you want to focus on late starts or only late finishes?

The short answer is you need to add a custom field (text) with a custom formula. For example:

IIf([Finish Variance]>0,"Red",IIf([% Complete]=100,"Blue",""))

You can then display graphical indicators for the "red" and "blue". You'll also want to figure out what you want to do for summary tasks. If one task is late, should the summary be marked late - even if its dates haven't yet changed?

However, that formula doesn't address issues like the task finished early, or the task has no baseline. I suggest coming up with a more complete metric than just late or done. Again, the Status indicator field is quite nice and no custom fields needed.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2013: language indicator in the status bar? franklekens Word 8 08-30-2015 01:08 PM
Error occurs when I open the tasks list in MS Project Professional 2013 from SharePoint 2013 VivekG1 Project 1 02-22-2015 10:59 AM
Can you review status in Project from a previous time prior to "Today" StevieMar Project 3 04-30-2014 09:42 AM
Who Does What When report in Project 2013 Smithy15 Project 1 01-20-2014 08:48 AM
MS Project Start Dates not matching the Status Date sjodom Project 3 12-04-2011 08:45 AM


All times are GMT -7. The time now is 06:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft