You need to sign in to do that
Don't have an account?
Laaral
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! :)
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! :)
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 :)