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
1 answer
18 views

SharePoine List Validation Issue

Good afternoon, I have a list where based on what the user selects for a business line they are presented a choice field for activities related to that business line. A flow then populates a generic &...
MofEnticer's user avatar
1 vote
1 answer
14 views

Control on date selection for new entry but not affect existing records

I have a list in SharePoint with a date column "Complete Date". I want to add a control to only allow users to select the complete date in current quarter. I used this formula: =IF(TODAY()&...
Ray's user avatar
  • 13
1 vote
1 answer
36 views

SharePoint list validation formula issue

This is the first time asking here. I'm trying to write a formula for list validation but I cannot understand what I'm missing. For this formula I need to chain 2 conditions [Start date]<= [End ...
Radu's user avatar
  • 11
2 votes
2 answers
2k views

Microsoft List validation not working in SharePoint Online - Error: The server was unable to save the form at this time. Please try again

I have a SharePoint Online List. It has some fields that are 'Required' fields. I am also trying to use List Validation so that: IF the value of MyChoiceColumn is Yes THEN the AdditionalInformation ...
user1063287's user avatar
1 vote
1 answer
303 views

Multiple sharepoint list date column validation in list settings

I am trying to add validation on multiple dates in SharePoint list. Example: If end date is added by user the start date shall be mandatory. The start date shall not be greater than end date. =IF(...
Mohammed Abdul Samad's user avatar
0 votes
1 answer
128 views

Making a Date field required in case the use select In-progress from a choice field using list validation formula

I have a SharePoint online custom list which contains 2 columns: StartDate of type Date Time Status of type Choice field which have values such as Open, In-Progress, Closed. Now I want to write a ...
John John's user avatar
1 vote
1 answer
301 views

List Validation with IF & LEN

SharePoint Guru's please guide me to complete List request. Requirements: I have been creating a List for doing User Audit Manager has to select the Choice either Approved or Rejected under Access ...
kirubakaran J's user avatar
0 votes
1 answer
191 views

SharePoint List Validation Settings gives me Syntax error

=IF([Urgency Level] = "XL", IF(ISBLANK([Date and Time of Production Stop just in case of XL]),false,true),true) I get a syntax error message with this formula. It tells me either the ...
Rambo's user avatar
  • 3
0 votes
1 answer
80 views

Need help with another sharepoint validation formula

I am trying to validate the Ticket Number field for certain task types and i am trying to validate the Manager email field for certain task types. My fields are like this: Task Type (Radio button ...
drgaprilfool's user avatar
1 vote
1 answer
49 views

Need help with my SharePoint list validation formula. I cant seem to figure out how to combine the below statements. Any help is appreciated!

I have a SharePoint list with the fields listed in bold at the bottom. I currently am using the below formula to validate that when options 1 and 3 are selected, I am requiring ticket number is not ...
drgaprilfool's user avatar
1 vote
1 answer
582 views

List Validation syntax error

I have a challenge with the List Validation process for a simple form. I need to check 2 fields: If [NPC Status] is "Passed" and [NPC End Date] greater or equal 2/24/2022. =IF([NPC Status]=&...
Artem's user avatar
  • 13
1 vote
1 answer
39 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 ...
swissbuechi's user avatar
0 votes
1 answer
165 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 ) ...
Osama Ashraf's user avatar
0 votes
1 answer
304 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 ...
Harris's user avatar
  • 593
1 vote
1 answer
307 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 [...
Augustika shukla's user avatar
1 vote
1 answer
3k 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 ...
ekoz's user avatar
  • 21
1 vote
1 answer
66 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) ...
Carrie Wong's user avatar
1 vote
1 answer
3k 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]...
cdfj's user avatar
  • 13
1 vote
1 answer
207 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([...
John John's user avatar
0 votes
1 answer
198 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 ...
seaandtea's user avatar
1 vote
3 answers
265 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 ...
mtagliaferri's user avatar
0 votes
1 answer
48 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&...
Darkstar.Industries's user avatar
0 votes
2 answers
53 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 ...
ChasEpes's user avatar
  • 109
0 votes
1 answer
45 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]&...
John John's user avatar
0 votes
1 answer
1k 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 ...
Tony's user avatar
  • 3
0 votes
1 answer
2k 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="...
grimatongueworm's user avatar
1 vote
1 answer
2k 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 ...
juanlo's user avatar
  • 13
0 votes
1 answer
2k 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: ...
Nas's user avatar
  • 59
0 votes
2 answers
698 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) ...
Nas's user avatar
  • 59
0 votes
2 answers
614 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 ...
Nas's user avatar
  • 59
0 votes
1 answer
781 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 ...
Nas's user avatar
  • 59
1 vote
2 answers
608 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 ...
Nas's user avatar
  • 59
2 votes
1 answer
303 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....
Nas's user avatar
  • 59
1 vote
2 answers
54 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 ...
eric's user avatar
  • 13
2 votes
1 answer
61 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 ...
Nico's user avatar
  • 33
1 vote
1 answer
265 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]="...
mtagliaferri's user avatar