I am putting together an evaluation form in Salesforce. I am using Customer object Greeting__c, the pick list values are High, Met, Below. I would like to assign a formula that sets "High" to numerical value 4 , "MET" to 2 and "Below" to 0. I cannot figure out how to configure the formaula. 1st question: Do I create a formula field to reference the Greeting_c API or create the formula in the Greeting__c in the formul editor?
Based on other questions here, I am trying (Greeting__c,"High",4) to return the picklist selection "High" with the number value 4. I am a beginner at this. Thank you in advance for your help. Any advice would be appreciated.