+ Start a Discussion
GabrielFuocoGabrielFuoco 

Workflow rule not working on accounts?

Guys, would like to have some help here.

I don't have an idea why this is not working...

 

I have a workflow rule where the formula looks like this:

OR
(ISCHANGED(BillingCity)||
ISCHANGED(BillingCountry)||
ISCHANGED(BillingPostalCode)||
ISCHANGED(BillingState)||
ISCHANGED(BillingStreet)
)

 It's set when created account and always when changed, it was supposed to create a taks for users with role "finance" and send them also an e-mail.

Well, it's not working... any clue?

 

The idea is to notify finance team when any billing info is changed on account's info.

 

Thanks in advance!!

Rahul_sgRahul_sg
try this
ISCHANGED(BillingCity)||
ISCHANGED(BillingCountry)||
ISCHANGED(BillingPostalCode)||
ISCHANGED(BillingState)||
ISCHANGED(BillingStreet)
Shannon HaleShannon Hale

You're mixing your operators.

 

The syntax for OR() is similar to Excel formula syntax, which is:

 

OR(
  condition1,
  condition2,
  condition3
)

 

Using the || operator is the method developers in other programming languages are more familiar with, which is:

 

condition1 || condition2 || condition3

 

They are two different ways of accomplishing the same thing, depending on what language you're used to. They aren't meant to be used together.

 

So you can either replace your || with commas, or remove the OR() function.

Marko LamotMarko Lamot

 

OR
(ISCHANGED(BillingCity),
ISCHANGED(BillingCountry),
ISCHANGED(BillingPostalCode),
ISCHANGED(BillingState),
ISCHANGED(BillingStreet)
)