You are here:
PRIORVALUE
Returns the previous value of a field.
Use
PRIORVALUE(field)
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 and setting input values in Process Builder.
- This function doesn’t return default values.
- When users create a record, this function returns the value of the field
referenced rather than null. For example, if you create an account named "Acme,"
PRIORVALUE(Account.Name)returnsAcme. - When using the ISPICKVAL function to return the previous value of a picklist field, include
the PRIORVALUE function inside the ISPICKVAL function as in this
example:
ISPICKVAL(PRIORVALUE (picklist_field), text_literal) - To check if the previous value of a multi-select picklist field includes a specific value,
use the PRIORVALUE function inside the INCLUDES function. For
example:
INCLUDES( PRIORVALUE(multiselect_picklist_field), text_literal )
This validation rule prevents users from changing the expected revenue of an opportunity after
it’s closed: AND(PRIORVALUE(Amount) > Amount,
IsClosed).

