Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 02, 2022 01:35 PM
I am looking for help creating a formula field to change the format that phone numbers appear in.
On Airtable, the phone field automatically formats phone numbers as: (555) 555-5555.
I need the phone numbers to be formatted as follows instead: +1 555-555-5555.
Please help!
Dec 05, 2022 12:58 PM
This formula should work.
"+1 " & SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Phone #}, '(', ''), ')', '')," ","-")
It finds and removes the parentheses with the SUBSTITUTE function, then finds the remaining " " (Space) and replaces it with "-". Then you just use the "&" operator to add "+1 " to the front.
Hope that helps!