none
How to set validation for column in list? RRS feed

  • Question

  • Hello,

    I want to set validation for column in list. The condition are :

    1. This column not required contains information
    2. But, there is validation when user insert info.

      Example:
      Column Email. 

      It's not mandatory field but once user insert the email info, there is validation as below

      =AND(ISERROR(FIND(" ";Emel;1));IF(ISERROR(FIND("@";Email;2));FALSE;AND(ISERROR(FIND("@";Email;FIND("@";Email;2)+1));IF(ISERROR(FIND(".";Email;FIND("@";Email;2)+2));FALSE;FIND(".";Email;FIND("@";Email;2)+2)<LEN(Email)))))

    Thank You

    Friday, February 2, 2018 12:40 PM

All replies