Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

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


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

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 09:30 AM.

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