I have a Picklist called Office__c. The Options look like this:
Argentina
Argentina - Cordoba
Argentina - Cuyo
Argentina - NOA
Argentina - Patagonia
Argentina - Rosario
I have a Formula field called Office_Group__c. What I'd like to do is strip the above field and enter in the first part of the text.
If a user selects "Argentina - Cuyo" the formula would take that and remove " - Cuyo" then only print "Argentina"
Also: Dependent picklist is not an option here.
Ideas?
답변 5개
You can add IF CONTAINS to do your exact requirement
Try this:IF(CONTAINS (TEXT(Office__c), "-"), LEFT(TEXT(Office__c),FIND("-", TEXT(Office__c))), TEXT(Office__c))
