Does Not Contain

I am looking to write a formula which says

IF A1="removed" AND A2 Does not contain "ABC", "true",""

What is the correct syntax for "does not contain" in this case? (I just can't get the typical "<>*ABC*" to work as part of a logic expression in Smartsheet.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!