function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Maddy6161Maddy6161 

How create a formula field for Auto Catch 1st 3 word from City + last 2 word from Country field

City Field             Country Field

Pune                    India

Formula Filed : PUNIN            like this
Best Answer chosen by Maddy6161
Ravi Dutt SharmaRavi Dutt Sharma
Try below formula, let me know if it works.
  
LEFT(City__c, 3)  + LEFT (TEXT(Country__c),2)

 

All Answers

Ravi Dutt SharmaRavi Dutt Sharma
Hey,

Create a formula field of type Text and paste below formula in it
  
LEFT(City__c, 3)  + LEFT (Country__c,2)

 
Maddy6161Maddy6161
Thanks Ravi  :   Country__c is a picklist field. 
Ravi Dutt SharmaRavi Dutt Sharma
Try below formula, let me know if it works.
  
LEFT(City__c, 3)  + LEFT (TEXT(Country__c),2)

 
This was selected as the best answer
Maddy6161Maddy6161
Thanks Ravi