You need to sign in to do that
Don't have an account?
HanSolo
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.
Any ideas on how to properly get the value of No to help determine the output would be great.
Thanks!
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.
Any ideas on how to properly get the value of No to help determine the output would be great.
Thanks!
Thanks,
Surender Patel.
All Answers
Thanks,
Surender Patel.