+ Start a Discussion
joez jojoez jo 

The formula expression is invalid: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Text

please help with Process builder

 

AND(
ISCHANGED([Lead].Lead_Stage__c),
TEXT([Lead].Lead_Stage__c ) = "reengaged", 
OR(
TEXT([Lead].Source_Subtype__c) = "CPL", 
TEXT([Lead].scorecarr__c)  = "CPL" 
)
)

Trailblazer7Trailblazer7
Try ISPICKVAL instead and recheck the options available in picklist fields.
AND(
ISCHANGED([Lead].Lead_Stage__c),
ISPICKVAL([Lead].Lead_Stage__c ) , "reengaged")
OR(
ISPICKVAL([Lead].Source_Subtype__c) , "CPL"), 
ISPICKVAL([Lead].scorecarr__c)  , "CPL" )
)
)


 
CharuDuttCharuDutt
Hii Joez 
Try Below Formula
AND(
ISCHANGED([Lead].Lead_Stage__c),
ISPICKVAL([Lead].Lead_Stage__c ) , "Reengaged"),
OR(
ISPICKVAL([Lead].Source_Subtype__c) , "CPL"), 
ISPICKVAL([Lead].scorecarr__c)  , "CPL" )
)
)
Please Mark It As Best Answer if it Helps
Thank You!
Andrew GAndrew G
Joez
I would check the fields that you are checking the TEXT() formula.

If any of the fields are Lead_Stage__c, Source_Subtype__c or scorecarr__c are text fields as opposed to being a Picklist or one of the other fields, it will throw an error as TEXT(textfield) will throw an error as the TEXT() formula does not know how to deal with a text field.

Once you identify which one is text field, remove the TEXT() formula from checking that field

regards
Andrew
veer soniveer soni
hy joez,
This type of error comes when you try to putting string field into Text.
For Example => Text(Name) => if  you will try like this then you will get the same error because Text() function means it convert any data type(Picklit,data,number) into text   and you are trying to putting text field so please don't put text filed.

Try following Formula.
AND(
ISCHANGED([Lead].Lead_Stage__c),
TEXT([Lead].Lead_Stage__c ) = "reengaged", 
OR(
TEXT([Lead].Source_Subtype__c) = "CPL", 
[Lead].scorecarr__c  = "CPL" 
)
)

I think [Lead].scorecarr__c field would be text type.whatever field is text don't put that into text() function.
Let me know if it helps you and don't forget to mark it as best answer.
Thank you