Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 05:45 AM
deepsk deepsk is offline RAG Status on Project 2013 Windows XP RAG Status on Project 2013 Office 2013
Novice
RAG Status on Project 2013
 
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 RAG Status on Project 2013 Windows 7 64bit RAG Status on Project 2013 Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
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 RAG Status on Project 2013 Windows XP RAG Status on Project 2013 Office 2013
Novice
RAG Status on Project 2013
 
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 RAG Status on Project 2013 Windows 7 64bit RAG Status on Project 2013 Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
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
RAG Status on Project 2013 Office 2013: language indicator in the status bar? franklekens Word 8 08-30-2015 01:08 PM
RAG Status on Project 2013 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
RAG Status on Project 2013 Who Does What When report in Project 2013 Smithy15 Project 1 01-20-2014 08:48 AM
RAG Status on Project 2013 MS Project Start Dates not matching the Status Date sjodom Project 3 12-04-2011 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 PM.


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