You need to sign in to do that
Don't have an account?
Emma Diaz 12
Process formula help needed
Hi community,
I am trying to use a formula in a Process to evaluate a PriorValue on a Picklist. I keep getting an error
The formula expression is invalid: Formula result is data type (Boolean), incompatible with expected data type (Text).
OR(
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Interest")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Meeting Scheduled")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Initial Scope")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Proposal"))
)
If I use the TEXT instead of ISPICKVAL I get
The formula expression is invalid: Incorrect number of parameters for function 'TEXT()'. Expected 1, received 2
HELP!
I am trying to use a formula in a Process to evaluate a PriorValue on a Picklist. I keep getting an error
The formula expression is invalid: Formula result is data type (Boolean), incompatible with expected data type (Text).
OR(
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Interest")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Meeting Scheduled")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Initial Scope")),
(ISPICKVAL(PRIORVALUE([Opportunity].StageName),"Proposal"))
)
If I use the TEXT instead of ISPICKVAL I get
The formula expression is invalid: Incorrect number of parameters for function 'TEXT()'. Expected 1, received 2
HELP!
Nayana K
Seems you want to return true or false based on whther picklist's priorvalue falls under some values.OR condition will return false. You are using a field of type of text and you are assigning this formula as value to this field in process which is wrong.
VineetKumar
Change your formulae type from Text to Boolean