You are here:
ISCHANGED
Compares the value of a field to the previous value and returns TRUE if the values are different. If the values are the same, this function returns FALSE.
Use
ISCHANGED(field) and replace
field with the name of the field you want to compare.
Tips
- This function is available only in:
- Assignment rules
- Validation rules
- Field updates
- Workflow rules if the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited .
- Formula criteria for executing actions in Process Builder.
- Use the NOT function to reverse the return values of TRUE and FALSE.
- This function returns FALSE when evaluating any field on a newly created record.
- If a text field was previously blank, this function returns TRUE when it contains any value.
- For number, percent, or currency fields, this function returns TRUE when:
- The field was blank and now contains any value
- The field was zero and now is blank
- The field was zero and now contains any other value
ISCHANGED(Name).NOT(AND(ISCHANGED(Priority),
ISPICKVAL(Priority, “Low”))) is a validation rule that ensures if a
user changes the Priority of a case, the new priority cannot be
“Low.”
NOT(AND(ISCHANGED(CloseDate),
OR(MONTH(CloseDate) <> MONTH(TODAY()), YEAR(CloseDate) <>
YEAR(TODAY())),$Profile.Name <> "Sales Manager")) is a validation rule that
prevents a user from changing the Close Date of an opportunity to a date outside of the
current month and year unless that user has the Sales Manager profile.

