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
LaaralLaaral 

Problem with formula concerning picklist

Hi,

I have a problem with my formula, idea is that start date(date field) + contract term (picklist) = End date (date). I don't know how to get this formula right, it says that Error: Field Service_Contract_Term__c is a picklist field. Picklist fields are only supported in certain functions. When I try to change the Contract term to TEXT(Contract Term) it still doesn't work in the formula. Please help! :)
Vinit_KumarVinit_Kumar
Try using ISPICKVAL function.

ISPICKVAL(<Field Name>, "<Text Value>")

Go thorugh the below link to learn more about using this function

https://help.salesforce.com/HTViewHelpDoc?id=customize_functions_i_z.htm&language=en_US#ISPICKVAL

If this helps,please mark it as best answer to help others :)