I've encrypted phone field is there and it referred in formula field. I need to remove special character in the formula field (tried with SUBSTITUE) but it is not allowing to change because it's a encrypted field. Could anyone suggest how to do it.

  • 2
    Recommend reviewing Supported Operators, Functions, and Actions for using Encrypted Data in Formulas Commented Aug 2, 2022 at 11:08
  • Thanks but I don't see, if in formula field contains (322)-(233)-(1091) and it should return 3222331091. I was able to do it for normal fields but encrypted fields not allowing.
    – Rhaan
    Commented Aug 2, 2022 at 16:48

1 Answer 1


As mentioned in the comments, SUBSTITUE() is not a supported Function for using Encrypted Data in Formulas.

There does not seem to be a direct/simple way to achieve what you are looking for. The workaround would be to create a physical field instead of a formula field, and populate it via trigger or workflow, then encrypt it.

You must log in to answer this question.

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