You need to sign in to do that
Don't have an account?
hemm
Using the value of a picklist field
I have added additional address fields in Salesforce and am using a pick list for the country name to help with data quality. I am trying to create links to map websites using a HYPERLINK formula field. I am including the country field in there, but the formula says that I can only include this field within the ISPICKVAL function.
Am I really unable to use the value selected in the picklist in a formula? Or do I have to create another formula with a CASE function that goes through every picklist value and provides a text equivalent?
If the latter, can you please add an enhancement request to be able to use the value from a picklist field as if it were text?
Thanks.
Am I really unable to use the value selected in the picklist in a formula? Or do I have to create another formula with a CASE function that goes through every picklist value and provides a text equivalent?
If the latter, can you please add an enhancement request to be able to use the value from a picklist field as if it were text?
Thanks.
We are capturing 4 different addresses. Each one has a country field with a list of countries (235 in the list). We have a Mailing Address Indicator field that allows a user to indicate which of these 4 are the primary Mailing Address. We then have formula fields to derive the Mailing Address for each Client based upon the selection in the Mailing Address Indicator. This allows you to do a mailing to the primary mailing address whether that address is the Home Address, Business Address, etc. Anyway, I was going through the process of creating formula fields. Examples below.
Field 1:
Code:
Field 2:
Code:
Since the formula fields have a character limit in each one, I had to break it into multiple fields. Once I got to field 3, I got beyond the number of characters that a formula field can process at once. Apparently, there is an overall processing limit. If you reference other formula fields in your formula field, Salesforce looks at the compiled size of all of them and has a limit on that. To work around limitation #1, I was going to need to create ~15 formula fields for each address. I got as far as field 3 and hit limitation #2.
Can this post act as my request for enhancement to the Salesforce product?
sorry to upload this thread, But I've got the same problem. Is there any solution since this thread ?
Thank you for the help ...
Mig