Microsoft Office Forums MS Project - RAG status formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-13-2018, 12:25 PM
imzkhan4 imzkhan4 is offline MS Project - RAG status formula Windows 10 MS Project - RAG status formula Office 2016
Novice
MS Project - RAG status formula
 
Join Date: Nov 2018
Posts: 1
imzkhan4 is on a distinguished road
Default MS Project - RAG status formula

Hi,

I would be very grateful for any assistance to create a formula for a RAG column in project. I have created graphical indicators but require a formula to update automatically.

I require a RAG column to provide the following parameters;

1) if milestone/task is complete 100% = Complete
2) if baseline finish date is greater/later than status date and not 100% complete = Green
3) if baseline finish date is earlier than status date and not 100% complete and equal to or more than 6 days overdue = Red
4) if baseline finish date is earlier than status date and not 100% complete and 1-5 or equal to 5 days overdue = Amber

I hope this makes sense and I would be grateful for any help.

Thank you in advance.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Project - RAG status formula Project Status and Overdue tasks stanleysamuel Project 1 10-12-2016 11:32 AM
Project Late Status Changes from One User to Another cookieburk Project 4 06-01-2016 12:31 PM
MS Project - RAG status formula Project Status and Late Tasks - Incorrect BarryB Project 4 08-02-2015 01:50 PM
RAG Status on Project 2013 deepsk Project 3 04-23-2015 07:26 AM
MS Project - RAG status formula 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 01:42 PM.


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