+ Start a Discussion

Problem with formula concerning picklist


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! :)
Try using ISPICKVAL function.

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

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


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