Questions tagged [validation-list-items]

The tag has no usage guidance.

0
votes
2answers
45 views

List Validation settings Error in Formula

I am trying make the Billing Status field required only when the A La Carte field is checked (true) or not blank (otherwise it is not required). I don't know whether to set this up in infopath or on ...
0
votes
3answers
35 views

Setting a column value in SharePoint validation

I want to do an IF statement and if its true then I want another column to be set.. I am using list validation on a Sharepoint list: =IF([Master vs Copy])="Master",([Duplicate Rationale])="None"), ...
1
vote
1answer
27 views

SharePoint list validation code not working

I have a requirement, if a user chooses 'Copy' from a drop down an additional field needs content, and if the user choose 'No-Copy' then the additional field CAN be blank. Here is my script and when ...
1
vote
1answer
25 views

Problem with app validation - SharePoint online

I have a very simple validation script , which compares a date added to the created date and if there is 6months after then it will NOT show an error but if it is before 6months after the created date ...
0
votes
2answers
30 views

List validation to force fields to be conditionally mandatory

I have a custom list inside sharepoint on-premises 2013, which have these fields:- Status. drop-down(Open,Closed). Type. drop-down(item,Box). Comment. Multiple line of text (allow pictures and tables)...
0
votes
1answer
59 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",...
0
votes
1answer
55 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 ...
1
vote
0answers
40 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
51 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
109 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
77 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
1answer
23 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
52 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
17 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
103 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 ...
4
votes
1answer
350 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
615 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
37 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
36 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
80 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
165 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
478 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
41 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 ...
0
votes
1answer
722 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. ...
2
votes
1answer
558 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 ...
5
votes
1answer
416 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
1k 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
3answers
57 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 ...