Searching a text in a string

I'm looking for a string "College 1" in a text and update Subcategory column with the text found. A helper column "College?" let me know that "Task Name" has "College" in Task Name.

"College 1" can be anywhere in the string

Please assist as my formula is not working.

Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!