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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!