Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
cinziet23

# sends email alerts when an opportunity is created or dates amounts and probability are changed

HI I would like to set a workflow rule that when is met, gives as workflow action an email alert.

My problem is about editing the rule criteria. As I'm totally new to formulas I don't understand what sintax to use to say:

ISCHANGED ( Amount) or that the close date or the probability are changed..I don't unedrstand the use of the operators and functions...

Many thanks

Shannon Hale

You got a good start. ISCHANGED() will check whether a value has changed since the last edit.

First, make sure your workflow rule set to evaluate when the opportunity is "created, and any time it’s edited".

Next, set your formula to the following:

```OR(
ISNEW(),
ISCHANGED( Amount ),
ISCHANGED( CloseDate ),
ISCHANGED( Probability )
)```

Basically, the OR() function contains a list of conditions, separated by commas. If one or more of the conditions is met (e.g. it's a new record, or the amount changes), then it returns true.

ISCHANGED() function: http://help.salesforce.com/help/doc/en/customize_functions_i_z.htm#ISCHANGED

Shannon Hale

You got a good start. ISCHANGED() will check whether a value has changed since the last edit.

First, make sure your workflow rule set to evaluate when the opportunity is "created, and any time it’s edited".

Next, set your formula to the following:

```OR(
ISNEW(),
ISCHANGED( Amount ),
ISCHANGED( CloseDate ),
ISCHANGED( Probability )
)```

Basically, the OR() function contains a list of conditions, separated by commas. If one or more of the conditions is met (e.g. it's a new record, or the amount changes), then it returns true.