I am writing a Formula Field to populate a ID. Here is the requirement I have a text field called work name where the end user gives values called "Core Work" or "Netflix" or "Capacity hoilder" and another field called Work ID which is a Text Field where end users give the field values as "123456"
Now I need to create a formula field called WORK CODE to populate the values "CW.123456" if the Work name field value is Core Work, if the Work name field value is "Netflix" then this formula field should populate "NT.123456", if the Work name field value is "Capacity hoilder" then this formula field should populate "CH.123456". I used the below logic
LEFT(Work_Name__c, 2) + Work_ID__c
but it is updating the new field to "Co123456" and "Ne123456". Please advice