Skip to main content
Meagan Lloyd 님이 #Data Management에 질문했습니다
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개
0/9000