Contract Expiry date less than 0,30,90,180 days from todays date apply RAG
I have a RAG dropdown column configured, a formula is required for the RAG to be applied against the following:
Expiry date 180 greater than todays date = Green
Expiry date is between 180 - 90 days greater than todays date = Yellow
Expiry date is between <0 - 60 days greater than todays date = Red
The Expiry date is a column and date formated.
Help Article Resources
Check out the Formula Handbook template!