Questions tagged [list-validation]

**List Validation** is one of the settings of list where you can specify a formula to use for validation. It create a message that helps users understand what valid data looks like.

Filter by
Sorted by
Tagged with
1
vote
1answer
22 views

Validate a column only if another column is not blank - Excel Formula not working

I need to add a column validation to my list. The requirement for the validation is that the column [Body] cant be empty if the column [Status] is one of this statuses: "1-Cancelled" or "2-Awaiting ...
0
votes
1answer
31 views

How to split a column by delimiter

I am working on a column in SharePoint List. Let's name this column as Column A. I need help to split this column by delimiter which is "-" into several columns. Here is the sample of column A: ...
0
votes
2answers
31 views

How to have validation for calculated column

I am working on a calculated column that take value from other two different columns. The formula is as this: =IF([Detect-Rental/Lease]=1,IF([Detect-Rental/Lease Taxonomy]="Yes",TRUE,FALSE),TRUE) ...
0
votes
2answers
34 views

How to validate decimal value

I am working on SharePoint list validation. In column A, it should only allowed whole number/integer to be entered and any decimal should return an error. I tried to set the number of decimal place ...
0
votes
1answer
14 views

Date must be more than 2 Years from today

I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more. How can I write the validation formula for this? Much appreciated if ...
1
vote
2answers
25 views

How to validate other special character other than ASCII

I am working on one of a Sharepoint list column validation. This column named: Description . The validation requirement is it will only take: 1) This character: Aa Bb Cc Dd Ee Ff Gg Hh Ii Jj Kk Ll Mm ...
2
votes
1answer
30 views

How to compare between rows in a same column

I working on to have a validation on a SharePoint list. One of the requirement is in Column A it should not contain serial number which are the numbers that in a manner only differ +1 from one another....
1
vote
2answers
32 views

How to enforce to input value from another column?

I've created 3 columns: Choice: Banana Apple Orange 2.Start date 3.End date If you select "banana", then he/she must input value for "start date" and "end date". I tried to input the formula ...
2
votes
1answer
40 views

SharePoint List column validation related to another item

I have a SP list with 3 fields: "report type" (choose list "A", "B" or "AB") "Type A due date" "Type B due date". I want to set-up column validation for the due date so that "Type A due date" is ...
1
vote
1answer
21 views

Multiple Validation Rule

I have the following validation rule that works perfectly which makes mandatory [Customer] and [Member] columns if column [Feedback Type] equals "Ticket" from a drop down list: =IF([Feedback Type]="...