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
GMASJGMASJ 

Is a picklist field. Picklist fields are only supported in certain functions

Hi,

  I do not know what is wrong in below formula picklist field it keeps giving error Please suggest me what is the error in below formula
 
  Error: Field Partner_Information__c is a picklist field. Picklist fields are only supported in certain functions.​ 
AND(
OR
(ISPICKVAL(Partner_Information__c, "Partner Sourced"),
 ISPICKVAL(Partner_Information__c, "Partner Influenced")
),
ISBLANK(Partner_Information__c)
)
Partner_Information__c is a pick list
Partner_Information__c is a lookup field 

Thanks
Sudhir
Best Answer chosen by GMASJ
RKSalesforceRKSalesforce
Hi Sudhir,

Please use below formula if your field is Picklist. I hope this will work: 
AND(
OR
(TEXT(ISPICKVAL(Partner_Information__c, "Partner Sourced")),
 TEXT(ISPICKVAL(Partner_Information__c, "Partner Influenced"))
),
ISBLANK(TEXT(Partner_Information__c))
)
Please mark as best answer if helped.

Regards,
Ramakant

All Answers

RKSalesforceRKSalesforce
Hi Sudhir,

Please use below formula if your field is Picklist. I hope this will work: 
AND(
OR
(TEXT(ISPICKVAL(Partner_Information__c, "Partner Sourced")),
 TEXT(ISPICKVAL(Partner_Information__c, "Partner Influenced"))
),
ISBLANK(TEXT(Partner_Information__c))
)
Please mark as best answer if helped.

Regards,
Ramakant
This was selected as the best answer
GMASJGMASJ
Thanks Ramakant, I am getting some different error now Please see below. 

Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Boolean

Thanks
Sudhir
RKSalesforceRKSalesforce
Please try using below  formula. I hope this will work: 
AND(
OR
(ISPICKVAL(Partner_Information__c, "Partner Sourced"),
 ISPICKVAL(Partner_Information__c, "Partner Influenced")
),
ISBLANK(TXT(Partner_Information__c))
)

Regards,
Ramakant​