Skip to main content
I have a custom contact field "Company" that contains our customer's company name. I want to create an "Industry" field that auto populates what industry the company falls into based on what text is in the Company field. Example: "Industry" field would populate "Agriculture" if it finds the text "farm, seed or ranch" in the Company filed.

 

I have a feeling I need to use some kind of a contains formula to do this but I'm not sure where I go in to define my industries and the criteria. Any help much appreciated!
5 Antworten
0/9000