UI-Only LEN in equalion

BillBill 💎
edited May 12, 2020 in Questions
What do I have wrong?

If (   LEN( {{Temp_10_Digits__c}}   )  ==  10
,
""
,
"The phone length is " & LEN({{Temp_10_Digits__c}}) & " digits, it needs to be 10 digits." 

Comments

  • Bill McCulloughBill McCullough 💎💎
    edited February 21, 2017
    Bill,

    I am not exactly sure, but I think the 'IF' must be uppercase and I don't think you can combine the LEN function along with text for the result if false.

    I was able to do what you are after by creating a second formula field called 'PhoneMessage' that would display the message you want when the value is false.  Here are the formulas for my 2 fields:

    PhoneCheck--> Formula field - Text output

    IF(LEN({{Phone}})==10,"",{{PhoneMessage}})

    PhoneMessage--> Formula field - Text output

    "The phone length is " + LEN({{Phone}}) + " digits, it needs to be 10 digits."

    Thanks,

    Bill
  • BillBill 💎
    edited May 12, 2020
    Thnak Bill
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!