function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Dave The RaveDave The Rave 

Process Builder - Formula Problem with Picklist fields

Process Builder - Formula Problem with Picklist fields
 
Within the formula section of the 'Immediate Actions' on the Process Builder, how can I join the text values together of the following 2 fields:
 
case.suppliedcompany
case.webproduct__c (picklist)
 
[Case].SuppliedCompany & TEXTVALUE([Case].WebProduct__c )
 
Expected Result: Case.Description = 'Salesforce Product123'
 
Error Message:
 
'The formula expression is invalid: Field Case is a picklist field. Picklist fields are only supported in certain functions'
 
See screenshot also
AbhishekAbhishek (Salesforce Developers) 
Dave,

Your query is answered here,

https://salesforce.stackexchange.com/questions/203205/the-formula-expression-is-invalid-field-case-is-a-picklist-field-picklist-fiel

https://developer.salesforce.com/forums/?id=906F0000000Ba3FIAS


Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Thanks.
Andrew GAndrew G
try 
[Case].SuppliedCompany & ' ' &  TEXT([Case].WebProduct__c )

i'm not familiar with Textvalue as a formula.


regards
Andrew