Retrieving one specific text/number


Hi, I'm looking to retrieve a specific text i.e. first warranty, second warrant, third warranty, initial order, labor only.

I'm using a countifs formula but I need to count any line which only has the word "warranty" in it.

Would I have to use a FIND formula?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!