Home › Forums › Discussion Forum › Project RAG Formula
Tagged: RAG
Hi
I have a project with start and finish dates I want to add a RAG Column which calculates like to
Red if Finish Date is Greater than 31 Dec 2015 Amber if Finish date is Greater than 31 Oct 2015 but less than 31 Dec 2015
Green if Finish date is less than 31 Oct 2015
Regards
John B
Pls see the picture here: https://tinyurl.com/quickRAG And also see Dale A. Howard (MVP)’s solution here for an alternative RAG scenario: https://answers.microsoft.com/en-us/office/forum/office_2013_release-project/rag-status-for-date-ranges/76f7c637-a7fd-401e-b543-2d713a9c949c
Remember Me
Please enter your username or email address. You will receive a link to create a new password via email.