# Contract Expiry date less than 0,30,90,180 days from todays date apply RAG

Options
✭✭

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.

• ✭✭✭✭
Options

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭✭✭
Options

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭
Options

Thank you, that works, I have altered the days to remove gaps. Appreciate your guidance.

• ✭✭✭✭
Options

Happy to help!

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!