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.
36
questions
1
vote
1
answer
12
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()&...
- 13
1
vote
1
answer
17
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 ...
- 11
1
vote
2
answers
1k
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 ...
- 214
1
vote
1
answer
223
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(...
0
votes
0
answers
13
views
How to validate incoming items & use AND/OR Function
I’m a bit confused on how to use the Validation Settings for SharePoint List/Discussion Board.
In my discussion board there is a Country Column and one of the default Subject Column. My intention is ...
- 1
0
votes
1
answer
91
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 ...
1
vote
1
answer
239
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 ...
0
votes
1
answer
138
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 ...
- 3
0
votes
1
answer
79
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 ...
- 37
1
vote
1
answer
44
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 ...
- 37
1
vote
1
answer
495
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]=&...
- 13
1
vote
1
answer
37
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 ...
- 113
0
votes
1
answer
131
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 ) ...
0
votes
1
answer
275
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 ...
- 581
1
vote
1
answer
276
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 [...
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 ...
- 21
1
vote
1
answer
57
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)
...
- 11
1
vote
1
answer
2k
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]...
- 13
1
vote
1
answer
174
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([...
0
votes
1
answer
167
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 ...
- 71
1
vote
3
answers
236
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 ...
- 63
0
votes
1
answer
43
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&...
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 ...
- 103
0
votes
1
answer
41
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]&...
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 ...
- 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="...
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 ...
- 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:
...
- 59
0
votes
2
answers
547
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)
...
- 59
0
votes
2
answers
526
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 ...
- 59
0
votes
1
answer
679
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 ...
- 59
1
vote
2
answers
565
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 ...
- 59
2
votes
1
answer
287
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....
- 59
1
vote
2
answers
51
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 ...
- 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 ...
- 33
1
vote
1
answer
261
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]="...
- 63