+ Start a Discussion
HanSoloHanSolo 

How to convert a picklist value to a different value + combine it to another picklist value to = a new combine string

I have a picklist field (QR_Service__c) with a value of "IA".
Another picklist field (Tax_Prep__c) with a value of "Yes".
I have a formula field (Quallified_Service__c) which combines the values of both picklists and outputs it to a text field (Qualified_Service__c) as: "Yes + IA"

I want to be able to change the word, "Yes" to "Tax Prep".
This would change the output to "Tax Prep + IA"

But if "No" is selected in the (Tax_Prep__c) picklist, the final output would be: "IA"

I tried a CASE function but its not accurate because I don't have the Yes or the No variable to determine the actual output. If someone was to select No, they would receive the same output as Yes, as shown here.
CASE (QR_Service__c,
"IA",'Tax Prep + IA',
"")
This is what the front end looks like.

User-added image
Any ideas on how to properly get the value of No to help determine the output would be great.

Thanks!
 
Best Answer chosen by HanSolo
Surender_PatelSurender_Patel
This works if I understood your requirement.
IF(Tax_Prep__c == 'Yes','Tax Prep + IA','IA')

Thanks,
Surender Patel.

All Answers

Surender_PatelSurender_Patel
This works if I understood your requirement.
IF(Tax_Prep__c == 'Yes','Tax Prep + IA','IA')

Thanks,
Surender Patel.
This was selected as the best answer
HanSoloHanSolo
Thank you!