Calculating days until expiration when the column has text along with dates

I'm new to Smartsheet and am stumped by formulas no matter how many YouTube videos I watch or articles I read - help! I'm trying to create a column that contains the number of days until contract expiration, but my contract expiration column also has text (5 different types - NA, Undefined, Unknown, NA, Until Terminated). My formula is working for the dates but I'm getting #InvalidOperation for the rows where one of the 5 text options is listed. Here's my formula:

=[Termination Date]@row - TODAY()

I'm sure it's an easy fix for those of you adept at formulas; I'm just not one of those people. Appreciate any assistance you can provide.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!