ShowAll Questionssorted byDate Posted
Dan Kidd

# Field changed > send e-mail alert Workflow rule

Hi,

This is my first post on SF dev forum, so be gentle :)

I'm trying to create a workflow rule to e-mail X users when the Billing Address on an Account is changed. I currently have the below rule set up but I can't get it to fire. Does anyone have any ideas to make this work/more elegant!
```AND(
OR(
ISCHANGED(BillingCity),
ISCHANGED(BillingStreet),
ISCHANGED(BillingState),
ISCHANGED(BillingPostalCode)),
NOT(ISBLANK( PRIORVALUE(BillingCity))),
NOT(ISBLANK( PRIORVALUE(BillingStreet))),
NOT(ISBLANK( PRIORVALUE(BillingState))),
NOT(ISBLANK( PRIORVALUE(BillingPostalCode))),
NOT(ISNEW())
)```

Dan
Best Answer chosen by Dan Kidd
Maharajan C
Hi Dan,

Please try the below Formula:

AND(
OR(
AND(NOT(ISBLANK(PRIORVALUE(BillingCity))),ISCHANGED(BillingCity)),
AND(NOT(ISBLANK(PRIORVALUE(BillingStreet))),ISCHANGED(BillingStreet)),
AND(NOT(ISBLANK(PRIORVALUE(BillingState))),ISCHANGED(BillingState)),
AND(NOT(ISBLANK(PRIORVALUE(BillingPostalCode))),ISCHANGED(BillingPostalCode))
),
NOT(ISNEW())
)

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj

Amit Chaudhary 8
Please try below formula
```OR(
ISCHANGED(BillingCity),
ISCHANGED(BillingStreet),
ISCHANGED(BillingState),
ISCHANGED(BillingPostalCode)
)```

Let us know if this will work

Maharajan C
Hi Dan,

Please try the below Formula:

AND(
OR(
AND(NOT(ISBLANK(PRIORVALUE(BillingCity))),ISCHANGED(BillingCity)),
AND(NOT(ISBLANK(PRIORVALUE(BillingStreet))),ISCHANGED(BillingStreet)),
AND(NOT(ISBLANK(PRIORVALUE(BillingState))),ISCHANGED(BillingState)),
AND(NOT(ISBLANK(PRIORVALUE(BillingPostalCode))),ISCHANGED(BillingPostalCode))
),
NOT(ISNEW())
)

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj

This was selected as the best answer
Dan Kidd
Thanks Raj! This worked a treat.