function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
iffuiffu 

Incorrect parameter for TEXT. Expected Number, Date, DateTime, received Picklist

Hi All,

 

I am just confused with this formula error in Rule Critirea of Workflow.The formula is;

 

IF(CONTAINS(Project__r.Project_Region__c, TEXT(Country__r.Region__c)), false, true) it throws an error saying;

 

Error: Incorrect parameter for TEXT. Expected Number, Date, DateTime, received Picklist

 

But when I am using TEXT() function for the picklist field in Add Field Update formula section - TEXT(Country__r.Region__c)) it works!

 

Any thoughts?

Thanks in advance!

Best Answer chosen by Admin (Salesforce Developers) 
iffuiffu

I resolved this by saying "true" in the rule critirea and added this formula in Field Update,

IF(CONTAINS(Project__r.Project_Region__c, TEXT(Country__r.Region__c)), Project__r.Project_Region__c, Project__r.Project_Region__c + ";" + TEXT(Country__r.Region__c))

And its now working fine as I want it to be...

 

But I am still curious, why is it throwing me the error in "Rule Critirea"?!