If Formula

So I'm working on a formula I just can't get right...

I'm trying to track expiration dates, so.. Id like...

Status to be Yellow if it's 60 days from today

red went is 30 days from today and Passed the expiration dated

and green for 61 days + if that makes sense


Please help !!!!

Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭

    Hello @Mstockbridge - I believe I have a formula to work for you. You'll need to change the [End Date] to whatever the "expiration date" column is named. Please try it and let me know.

    =IF([End Date]@row > TODAY(+60), "Green", IF([End Date]@row > TODAY(+30), "Yellow", "Red"))

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!