1

I'm wondering if it is possible to create a formula field that will display the previous value of a text field.

Example: If an account name is changed, display that previous value in the formula field. I tried: PRIORVALUE(Name) but received an error of "PRIORVALUE may not be used in this type of formula"

1 Answer 1

4

No, there is no formula for this; formula functions like ISCHANGED and PRIORVALUE only work in the context when a field value is transitioning from one value to another (i.e. during a DML update). Old values are not stored in the database (other than field history, which can't be used in a formula anyways).

The best you could do is create a text field called something like "Field Previous Value," then set a Process Builder/Workflow Rule that copies the prior value of the field to this second text field when the field changes. As a workflow example: "Evaluate when the following formula is true: ISCHANGED(FieldName)" with a workflow field update "Previous Field Value set to formula PRIORVALUE(FieldName).

1
  • @tDactyl You're welcome. Always glad to help.
    – sfdcfox
    Nov 6, 2018 at 17:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .