Apex Code Development You need to sign in to do that
Don't have an account?
DX-Noob Help using ISPICKVAL to populate a number field
Looking for help trying to figure out this error. We are creating a points system based on the number of times something is published. I'm trying to create a formula that will enter a specific number into number field after the prospect becomes a customer. I've already created the workflow, I just having some trouble with the formula to generate the number. The number field needs to be editable so that it can be overridden by the sales manager. It also needs to be a number so that we can use it in reporting calculations.
Here's the formula I am trying to work with for the field update:
IF(ISPICKVAL (Publishing_Schedule__c = "Weekly"),"1",IF(ISPICKVAL(Publishing_Schedule__c = "Daily"),"7",IF(ISPICKVAL(Publishing_Schedule__c = "Monthly"),"0.25",IF(ISPICKVAL(Publishing_Schedule__c = "Biweekly"),"0.50",IF(ISPICKVAL(Publishing_Schedule__c = "Semiweekly"),"2")))))
The error I receive is: Error: Field Publishing_Schedule__c is a picklist field. Picklist fields are only supported in certain functions.
What is the datatype of your Formula Field? If it's a Formula(Number) then you have to remove the quotes from around the number in your formula.
Also your formula is missing an Else Result.
If you're evaluating the same Picklist field multiple time you're better off using a CASE function like this:
All Answers
What is the datatype of your Formula Field? If it's a Formula(Number) then you have to remove the quotes from around the number in your formula.
Also your formula is missing an Else Result.
If you're evaluating the same Picklist field multiple time you're better off using a CASE function like this:
Thanks, it worked like a champ. I haven't really used CASE all that often, but it makes sense in this scenario.