Architect expression to format phone number fails silently

Architect & Flows
1

Trying to strip the country code and format a number like +18005551234 into (800) 555-1234 using an Architect expression. The standard substring and replace functions don’t seem to play nice together in a single node. Here’s what I’ve tried:

  • Used REPLACE(FORMAT_PHONE_NUMBER(contact.phone, "E164"), "+1", "") but it just returns the raw string.
  • Tried chaining SUBSTR calls, but the syntax keeps throwing a validation error on save.

Is there a specific function I’m missing? The docs are vague on complex formatting.