Formula help for date <90 days and text "includes"

Tana V
Tana V ✭✭✭✭
edited 11/21/23 in Formulas and Functions

So really stumped on this one, my formula is working with the exception of the text including "Test".

I need to have a star (1) put into this cell IF:

Column [Expiration Date] is <= 90 days from today AND another column (Client) includes the word "Test". My current formula (auto-generated) is not working, any help is much appreciated!!

My current formula:

IF(AND(NOT(ISBLANK([Expiration date]@row)), [Expiration Date]@row - TODAY() <= 90, Client@row <> "Test"), 1, "")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!