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
0 votes
0 answers
9 views

Conditional Required Field in SharePoint Online Library Validation Syntax Error

Goal I have a "Managed Services" Choice column with predefined choices displaying as Checkboxes (allow multiple selections). I want to make another column required based on the selection of ...
user avatar
0 votes
1 answer
19 views

Combining two different validation in SharePoint list

I have a List with multiple columns and want to do validation on 2 columns based on the value of a drop-down list and want to do validation on the list with the following conditions. Column 1 ( Type ) ...
user avatar
0 votes
1 answer
30 views

Conditional Required Field in SharePoint Library

I know how I can make the conditional formatting based on one selection, but I have an issue with multiple selections. I have a City dropdown column with three options: Test, Test1, Test3. My other ...
user avatar
  • 507
1 vote
1 answer
26 views

Setting up a validation column using created by column in SharePoint lists

I am looking to create a validation formula using the [Created By] column that comes in default SharePoint lists but cannot understand the right syntax to do so. What I'm trying to achieve: IF [...
user avatar
1 vote
1 answer
78 views

Column validation of sharepoint list

I am trying to create a column validation based on the other column's output and I constantly get the error. I have 2 fields: Testing - choice column with the value "Yes" or null. Test date ...
user avatar
  • 21
1 vote
1 answer
28 views

SharePoint List - Column Validation

I want to write 2 formula to validate below conditions: I have 3 columns in SharePoint list: Date of Booster (Date field) Is resident in Hospice? (Yes/No Field) Date Admission at Hospice (Date Field) ...
user avatar
1 vote
1 answer
39 views

List validation if then syntax

I am trying to use list validation to enforce that the value in the Category choice column is compatible with a value in the Activity choice column (1:1) If [Activity] = "Walking"; [Category]...
user avatar
  • 13
1 vote
1 answer
84 views

Apply the list validation to only certain content types

I have the following formula inside the list validation: =IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE)=IF(Status="Commission Paid",IF([...
user avatar
  • 2,214
0 votes
1 answer
50 views

Complex Column Validation Formula

I need to add validation to a single line of text column in a SharePoint list. For other reasons, the column must be a single line of text, but it needs to be formatted like a date. The column must ...
user avatar
1 vote
3 answers
102 views

Validation IF Column

I am stuck on a validation column, I need Date Effective From mandatory if Approval Status is equal to Approved and vice versa I need Approval Status mandatory if Date Effective From is not blank. I ...
user avatar
0 votes
1 answer
25 views

List validation - Multiple Columns

Hopefully this is really simple, but I can't get my mind around it. At the title suggests, I have a series of column. Towards the end of them there are 3 columns, "Level 2", "Level 3&...
user avatar
0 votes
2 answers
49 views

SP 2013 List Validation: enforce sequential dates

I'm having formula and logic trouble getting a list validation formula that will force the user to enter four dates in sequential order. I have Date1, Date2, Date3, and Date4. I also need to skip a ...
user avatar
0 votes
1 answer
34 views

List validation exclude a validation if a field contain certain value

I have the following list validation:- =IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE)=IF(Status="Commission Paid",IF([Commission Paid Date]&...
user avatar
0 votes
1 answer
436 views

Validation user message not showing

I have a formula in List settings-> validation settings. The formula validates correctly. The user message I entered does not display, it displays its own message below which is Error: The ...
user avatar
  • 3
0 votes
1 answer
1k views

Validating Multiple, Unrelated Conditions

In my list, I have several pairs of fields that need separate validation. I can do them individually, but I can't find the syntax to string them together. Here's condition 1: =IF(Outcome="...
user avatar
1 vote
1 answer
816 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 ...
user avatar
  • 13
0 votes
1 answer
662 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: ...
user avatar
  • 59
0 votes
2 answers
88 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) ...
user avatar
  • 59
0 votes
2 answers
203 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 ...
user avatar
  • 59
0 votes
1 answer
161 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 ...
user avatar
  • 59
1 vote
2 answers
223 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 ...
user avatar
  • 59
2 votes
1 answer
141 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....
user avatar
  • 59
1 vote
2 answers
43 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 ...
user avatar
  • 13
2 votes
1 answer
50 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 ...
user avatar
  • 33
1 vote
1 answer
166 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]="...
user avatar