Searching a text in a string

Caravan

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.

Caravan

Please ignore my ask. I found my error.

Thanks

Andrée Starå

Hi @Caravan

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!