How to validate a non required column in SharePoint 2010?

How to validate a non required column in SharePoint 2010?

Since I only want my column validation to run if the user enters something in the field, that is to say, if the field’s value isn’t NULL, my first thought was to use the ISNULL () function and then wrap it in the NOT () function. (Note: Microsoft has a section with information about available Formulas and Functions in SharePoint 2010.)

How to do column validation based on non blank field?

I recommend to set formula in list validation settings as below to achieve this goal: =OR (AND (ISBLANK (Title),ISBLANK (Email)),AND (NOT (ISBLANK (Title)),NOT (ISBLANK (Email))),ISBLANK (Title)) Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help.

Can a valid validation formula refer to another column?

At the column level, a valid validation formula cannot refer to another column. If you attempt this, SharePoint will throw an error. [su_row] [su_column size=”3/4\\Let’s take the following scenario as an example to understand how this could be beneficial: A user is filling out a form on their medical history.

When do I need to validate a field in SharePoint?

Requirement: In a custom SharePoint 2013 list, User’s requirement is to validate a required field based on another field’s value. E.g. In a “Project Cost” list, the user must fill “Budget Amount” field value if “Budget Approved” field’s value is set to “True”.

Can You validate an empty field in SharePoint?

However, it validates fine if the field is empty. Next, we’ll put a simple validation place of the FALSE result. Let’s try to only allow the letter “A” there. So a user can leave it blank, or they can enter a single letter “A”, but nothing else will be allowed.

How to conditional requiring fields using SharePoint 2010 list validation?

The first part is simple: This just states that if FieldA has the value of “ShareBlog” then the validation passes, otherwise it fails. If you want to ouput text, rather than just check to see if it validation passes you can use the IF function. The above formula can be rewritten as:

When do you need to validate data in a field?

If users may be setting the field’s value in a UI other than the standard New or Edit (list item) forms, then you should also validate data that users enter into the field’s UI control. In particular we recommend that if the field is required to have a value, this requirement should be enforced at the UI level.

Can a NULL column be valid in SharePoint?

This method should work fine on Number columns, however, a column of data type Single line of text isn’t NULL if it’s empty, it just has a string of no length. This moved me back in the direction of using nested IF () functions like I did in my post on How to Use ‘OR’ Type Options in SharePoint 2010 Column Validation.