Loading
Salesforce now sends email only from verified domains. Read More
Extend Salesforce with Clicks, Not Code
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          PRIORVALUE

          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) returns Acme.
          • 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
            )
          Validation Rule Example
          Validation Rule Example

          This validation rule prevents users from changing the expected revenue of an opportunity after it’s closed: AND(PRIORVALUE(Amount) > Amount, IsClosed).

           
          Loading
          Salesforce Help | Article