validation rule on when case status is closed then not possible to re-open

Question

my requirement is : When case status is Approved or Rejected , then not possible to re-open the case and show alert like "Approved / Rejected cases not possible to open...." How can we acheive through Validation rule ? I tried below code but not works:

AND(
    TEXT( Status ) = "Approved",
    OR(
        TEXT(Status ) = "Rejected")
    )

pls correct or give any suggestions...Thanks

Answer 1

You could create a validation rule like below:

OR(
   TEXT(PRIORVALUE(Status)) = 'Approved',
   TEXT(PRIORVALUE(Status)) = 'Rejected'
)

Then just add your "Error Message" as: "Approved / Rejected cases not possible to open"

I would change the "Error Location" to Field and select "Status".

Keep in mind that this VR would apply to EVERY user, including Admins. If you would like to eliminate Admins or any Profile, that would need to be included in the VR as well. Let me know if that's the case.