+ Start a Discussion
uzairuzair 

Using Picklist field in CONTAINS() in formula field

Hi All,

 

I'm writing a formula to formula field and I'm  exceeding the compiled size limit.

 

Is there any alternate for the following code :

 

CONTAINS( TEXT(Product_Name__c ), "Connect")

 Here Product_Name__c is a Picklist field.

 

Any help regarding this would be highly appreciated.

 

Thanks in Advance.

SteveMo__cSteveMo__c

That doesn't sound right, in order for that to exceed the Compile Size limit you must be referencing another formula somewhere.

uzairuzair

Sorry for the Late response.

 

I'm not referencing any formula in this.

I'm using 10 criterias in the formula where i'm using picklist field with different values.

 

Any help would be highly appreciated.

 

Thanks in Advance.

SteveMo__cSteveMo__c

Can you post the complete formula?  You said that you were getting a Compile Size Limit error, but you posted just 1 line of code, now you're saying that you have "10 Criterias".  

 

It's kinda hard for someone to just guess what is wrong with your formula when you don't provide all of the information.

SteveMo__cSteveMo__c

I need to see the complete formula in order to try to help you, without that I can't.

SteveMo__cSteveMo__c

Okay the only thing I can suggest to getting rid of all the TEXT functions in your formula, there is a pretty big compile size hit using the TEXT function, that might be enough to get you under 5K