You need to sign in to do that
Don't have an account?
kshannon
Extra AND error in Workflow Formula
Hey,
I am trying to create a workflow formula that will check to see if my amount due was changed in my payment detail. but only if the opportunity's stage is equal to one of 3 choices.
I have this written out, but continue to struggle with an Extra AND error...
ISCHANGED( Amount_Due__c ) AND (ISPICKVAL(Donation__r.StageName , "Agreement Executed")),
(ISPICKVAL(Donation__r.StageName , "Receiving Funding")),
(ISPICKVAL(Donation__r.StageName , "Closed Fully Funded"))
)
If someone could please advise.
Thanks,
Kyle
you are picking one among the 3 choices that is you are implementing OR excluievly not AND.
SCHANGED( Amount_Due__c )
AND(ISPICKVAL(Donation__r.StageName , "Agreement Executed")),Place OR instead of AND.
If this answers your question make it as a solution.
No, this is not what I mean...
I want Amount due to be changed AND Stage is one of these 3 values.
Also, whether it is OR or AND the Extra error still shows.
So you want the amount due to be changed if the stage value is X1, X2, or X3?
If that is the case, dont use a formula... Just use the standard selections.
Stage Equeals X1, X2, X3
Then create a field update.
PB
Ahh I said this incorrectly sorry..
IF ISCHANGED(Amount_Due__c) AND (Stage = This OR That OR ThisThat)
But this is causing an error.
try this-
AND(
ISCHANGED( Amount_Due__c),
OR (
ISPICKVAL(Donation__r.StageName , "Agreement Executed"),
ISPICKVAL(Donation__r.StageName , "Receiving Funding"),
ISPICKVAL(Donation__r.StageName , "Closed Fully Funded")
)
)
Regards.
-P