5 Responses

  1. balu
    balu at |

    how to write a formula for the phone number having 10digit in sharepoint 2010 customlist
    can any once help me .

  2. Kide
    Kide at |

    hi balu, please try this method:

    1. Create a phone_number column which is Single Line of Text or Number type.
    2. Type this formula “=IF(LEN([phone_number])=10,TRUE,FALSE)” in Column Validation section, and type the validation message.

  3. BoostSolutions
    BoostSolutions at |

    Hi, balu, try and see if Kide’s method works 🙂

  4. subrahmanyam
    subrahmanyam at |

    Hi balu you can try this one it will match to your requirements
    =IF(LEN([phone_number])=10,ISNUMBER((TRUE,FALSE),FALSE) it will check length and entered chars or numeric or not

  5. venu
    venu at |


    Could someone please provide me the formula to accept only last 3 digits of the SSN and field should look something like this XXX-XX-X123. these characters should be standard XXX-XX-X and the end user should only be allowed to enter last 3 digits. I am on MOSS 2007 environment. Any help is greatly appreciated.

Leave a Reply