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
Check out the Formula Handbook template!