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. subrahmanyam
    subrahmanyam at |

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

Leave a Reply