RAG Formula with Reference to Start, end date and Status
Hi, I am aiming to create a RAG status referencing to three columns in a sheets. Wondering if anyone would be able to help me creating a formula that covers the following scenarios:
By the Work Start Date:
Not Started = Red
In Design = Amber
In Development / In Testing / Delivered = Green
By the Work End Date:
Not Started / In Design = Red
In Development / In Testing = Amber
Delivered = Green.
Many many thanks!!!
Help Article Resources
Check out the Formula Handbook template!