Skip to main content
ETO Results | Formula: Format Phone Number

BO 4.3 Platform

Updated over a year ago

This article provides the Formula for formatting a telephone number in ETO Results as: (###) - ### - ####.

Phone Format Formula:
=If Left([PHONE];1)="(" then [PHONE] ElseIf Substr([PHONE];4;1)="-" Then ("(" + Left([PHONE];3) + ") " +Right([PHONE];8)) Elseif [PHONE] > "1" Then ("(" + Left([PHONE];3) + ") " + Substr([PHONE];4;3) + "-" + Right([PHONE];4))
โ€‹
This Formula can be used for any phone number field in ETO. Replace [PHONE] with the exact phone number field.

Did this answer your question?