+ Start a Discussion
kshannonkshannon 

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

Suresh RaghuramSuresh Raghuram

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.

kshannonkshannon

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.

TrimbleAgTrimbleAg

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

kshannonkshannon

Ahh I said this incorrectly sorry..

 

 

IF ISCHANGED(Amount_Due__c) AND (Stage = This OR That OR ThisThat)

 

But this is causing an error.

Prafull G.Prafull G.

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