Return Text based on a date

Debbie Petersen
Debbie Petersen ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to write a formula that will return the text "Current" or Expired in the INS status Column based on whether the dates in the GL, AUTO and WC dates are past today's date.  Hitting a wall.  Attached snip of the sheet

Thank you in advance for any help!

Capture.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!