Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-13-2018, 12:25 PM
imzkhan4 imzkhan4 is offline Windows 10 Office 2016
Novice
 
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
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
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 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:16 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