Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [validation-list-items]

The tag has no usage guidance.

0
votes
1answer
23 views

Sharepoint Column Validation from another list

I have a custom list where a user enters information about a vehicle. I want to validate what the user enters as Vehicle ID, against a master Vehicle ID list contained in a seperate custom list. Is ...
0
votes
1answer
21 views

Conditional Required Field in SharePoint List (Exact text match)

I need to write a rule to conditionally require data in a field based on the values in two other columns: Status Column: Values include "Active" or "Inactive" Type Column: Values include "Full Time",...
1
vote
0answers
11 views

Field Validation in Element.xml (Schema.xml) SharePoint 2013 List

I have custom list in SharePoint 2013. That custom list made in element.xml and schema.xml. I am trying to put validation on list field using below method. For ex : https://docs.microsoft.com/en-us/...
2
votes
1answer
31 views

SharePoint Validation

I have a SharePoint site already created. I have noticed that members that are using my site will add their name to the "Name" Column, but they will not use the next Column "Decision" in some ...
2
votes
2answers
50 views

How to perform list validation using if statement?

If column [Status] = 'Approved' then [Run Date] must be >= today() I cannot seem to get the syntax for this validation correct. Can anyone help out? I understand the validation has to return true....
0
votes
1answer
28 views

SharePoint Validation formula help

I am attempting to make a condition where someone is inputting a new item on a list but for three specific fields, end users can only fill in one of those three. I can't figure out the formula syntax. ...
1
vote
2answers
42 views

sharepoint data entry validation

I want my data entry to not be on a list of exempted entries. I want to use a list of entries. But am open to suggestion Tested in excel by placing exceptions in a column. Extracted to sharepoint a ...
0
votes
0answers
8 views

75% duration of 'Start Date'

Using SP 2016 with a site list where users can pick a Start Date and End Date. Included a formula where the Start Date can not be set to the past: =[Start Date]>=TODAY() Included a formula where ...
0
votes
1answer
22 views

Column validation sharepoint list.Whats wrong with this formula

H All, I have a date i need to validate to make sure the user picks a date not less that todays date. I typed in this formula below ="Review Date"<TODAY() that works for the validation. but ...
3
votes
1answer
33 views

Individual column Validation Based Off The Previous Date Columns

SharePoint Online Classic View Really need some help with this. I have a custom list with 8 visible date columns Column name examples: Create Date, Start Date, O365 Queue and Date Closed. Create ...
0
votes
0answers
12 views

Error Message for List Validation on Custom Forms

I created a list validation as below: =NOT([Field1]=[Field2]) Goal is to avoid two choice columns having the same value. This works perfectly when using the default New and Edit forms. When using ...
1
vote
1answer
21 views

Where is the validation hidden?

I have a list that includes some sort of validation. It's not the simple validation formula in the list settings, but obviously embedded somewhere else in the system... and I'm wondering where? Date ...
0
votes
2answers
31 views

SP2013 Validation - If NULL, show N/A

I have a list that I'd like to do some validation on, but I'm having trouble with the exact syntax of the idea (if it's even possible). The idea is that if a list item's field is NULL, then the ...
0
votes
1answer
228 views

How do I “validate” a column/field only if it's not blank

I currently have a column called "MAC Address" - it is not a required field as some pieces of gear do not have an address, but unique values are enforced. If a user puts in an address I want to (at ...
0
votes
1answer
30 views

Help combine IF formulas for list validation

can someone help me? I want to combine two 5 lines of validation in a sharepoint list. I have been able to write a formula for one 1 line but not one that can combine all five validations. Line 1 IF ...
0
votes
1answer
34 views

Trying to validate column with formula

I have text field called ID Proyecto into list and I want to add column validation to accept no more than 6 digits so into Column Validation I add: =LEN(ID Proyecto) < 7 But I get Formula ...
0
votes
2answers
66 views

error when trying to set multiple list validation formulas inside my custom list Validation Settings

I want to add these validations to my list:- if the status= "Invoiced", then user must enter a value inside the "Customer Invoice Date". if the status = "Paid", then the user must enter a value ...
1
vote
1answer
140 views

JSOM validate list item without updating

I have a custom form on a SharePoint page that is intended to add and update list items. I want to validate values before updating. I found both the SP.ListItem.validateUpdateListItem and the SP.Field....
2
votes
1answer
210 views

List Validation Formula

I am attempting to put some validation into a list (List Settings > List validation) and I am struggling to get it to work. I have a list with 3 fields in it: Job Type Partner Agent Job Type has ...
3
votes
0answers
38 views

SP13 - How to stop sync ListItem[where item is updated] in variation list

I have two sites "/EN" - (source) and "/DE" (target). Where i add ListItem in list on "/EN" Site, he go to "/DE/". I want where i edit the same ListItem in "/EN", content in listItem does not change ...
4
votes
1answer
316 views

SharePoint 2013 People Picker Field Should Not be current User

Would be very Grateful if you can kindly please help me out I have a New Item Form with a PeoplePicker field with Allow Multiple Selection setting The Requirement is the Current User who is filling ...
0
votes
1answer
472 views

validate date column with AND and Today()

I want my "Day" column to validate as such: It can only be within 14 days in the past It can only be a past date or current day It can not be before June 21 It can not be not be after August 26. ...
5
votes
1answer
348 views

Column Validation Settings for a mandatory choice

I have a SharePoint 2013 list with 3 dropdowns of which 1 must be selected. It doesn't matter which is selected as long as one of them has data. I tried to do the Validation Settings: =IF(AND(...
3
votes
2answers
728 views

SharePoint Field Validation less than or equal to 7

I need to validate a Text field and ensure the number enter is anything between 0 and 7. I tried many options but can't get it. What syntax do i add to this to allow any number from 0 thru 7 to be ...
2
votes
1answer
465 views

Form Validation, if is not blank do validation

Hello i have a list with 2 date columns, [Date1] , [Date2], How do i excecute the next validation on te list validation, only if that fields are not empty: =[Date2]>[Date1]] i want the users can ...
2
votes
3answers
56 views

Hide/Disable a few columns from entering in SPList

I have a SPList, say LIST1, in which I will enter values for 6 columns [single line of text] while adding items. Now, I have a requirement, in which out of 6 columns, 4 columns should not be entered ...