Formula for status

Options
RSanders
RSanders ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi, 

Can I please have help with a formula. 

I want to show in a status column the following status':

Current - if expiry date hasn't been reached

Expiring Soon - If expiry date is in the next 60 days

Expired - If expiry date is today or greater than today

 

Column name for Date is "Expiry Date"

 

Thanks, really appreciate any help

Comments

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Options

    Hi RSanders

    Try:

    =IF([Expiry Date]1 < TODAY(), "Expired", IF([Expiry Date]1 < TODAY() + 60, "Expiring Soon", "Current"))

    I believe this works to your logic!

    Kind regards








    Debbie Sawyer Consultant & Training Manager

     

     

    Smarter Processes mean happy people in successful businesses