Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [validation-list-items]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
656 views

SharePoint Calendar Validation for 15 Minute Meetings

I'm trying to setup a SharePoint Online Calendar to only allow users to setup appointments in 15 minute increments starting at the top of the our. For example, 8:00 to 8:15, 8:15 to 8:30 and so on. I'...
Brian's user avatar
  • 11
0 votes
1 answer
207 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
2 answers
24 views

I am trying to force three fields to be populated if the value of one field is a specific item

I can validate one field with no problem but everything I do to validate multiple fails. I need to add another two though so FIELD3 and FIELD4. =IF([FIELD1]="Specific Value",IF([FIELD2]<&...
BennyG78's user avatar
0 votes
1 answer
47 views

Sharepoint list : Mandate a column based on value of another column

I have a list "Budget Tracker" which has Budget Status, [Raised Date](Date & Time), [Approved Date](Date & Time), Expense Type and [Expense Details](single line item) as columns. I ...
Ritu Kumari's user avatar
0 votes
1 answer
727 views

Document Library List Validation Error while uploading files to the folder

I'm using validation rule in document library (document set content type) which works fine while creating a list in the document library. However, when I try to upload document to the folder I receive ...
Abbas's user avatar
  • 25
1 vote
1 answer
38 views

ListItem.Update() triggers validation of all properties

I need to do a scheduled or manually trigger update on some hidden properties of files and folders. The items all have different content types with different properties, but the hidden properties are ...
Marvin's user avatar
  • 11
1 vote
1 answer
243 views

Help with date list validation and blank fields

New to Sharepoint trying to find my way:) I have the following structure : StartDate1,EndDate1,StartDate2,EndDate2 StartDate1 and EndDate1 are mandatory fields. StartDate2 and EndDate2 are not. I’m ...
LoukasTS's user avatar
0 votes
1 answer
79 views

Item Validation error message customization

I have a question regarding SharePoint item validation. Is there a way to customize how the error message from item validation is rendered? For example, to apply some CSS, or to alter it's placement ...
Tony Shuraputra's user avatar
0 votes
2 answers
297 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 ...
vier111's user avatar
  • 145
0 votes
3 answers
509 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"), ...
Jason Hough's user avatar
1 vote
1 answer
542 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 ...
Jason Hough's user avatar
1 vote
1 answer
27 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 ...
Jason Hough's user avatar
0 votes
2 answers
245 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)...
John John's user avatar
0 votes
1 answer
1k 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 ...
Daryl's user avatar
  • 127
0 votes
1 answer
3k 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",...
Leslie Jones's user avatar
1 vote
1 answer
406 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/...
heena sahi's user avatar
2 votes
1 answer
70 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 ...
Travis Horne's user avatar
2 votes
2 answers
5k 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....
Gen's user avatar
  • 23
0 votes
1 answer
35 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. ...
Ryan's user avatar
  • 11
1 vote
2 answers
696 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 ...
Neigh's user avatar
  • 11
0 votes
1 answer
32 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 ...
naijacoder's user avatar
  • 4,282
3 votes
1 answer
189 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 ...
Mile T.'s user avatar
  • 155
1 vote
1 answer
32 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 ...
Maxcot's user avatar
  • 193
1 vote
2 answers
3k 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 ...
DanJ's user avatar
  • 164
0 votes
1 answer
4k 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 ...
Chris Plonka's user avatar
0 votes
1 answer
113 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 ...
Dvnak's user avatar
  • 1
0 votes
1 answer
43 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 ...
David's user avatar
  • 177
0 votes
2 answers
434 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 ...
John John's user avatar
1 vote
1 answer
439 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....
broken-e's user avatar
  • 131
2 votes
1 answer
3k 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 ...
snowmansmartie's user avatar
3 votes
0 answers
54 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 ...
Goshky's user avatar
  • 2,058
4 votes
1 answer
687 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 ...
Arvind's user avatar
  • 41
0 votes
1 answer
2k 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. ...
Maureen's user avatar
  • 687
5 votes
1 answer
473 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(...
Kimberly Abaid's user avatar
3 votes
2 answers
3k 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 ...
Rob A.'s user avatar
  • 33
2 votes
1 answer
1k 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 ...
Juansei's user avatar
  • 103
2 votes
3 answers
216 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 ...
samolpp2's user avatar
  • 3,500
1 vote
2 answers
988 views

How to validate for file attachment size during list item save

I have a custom list form that implements OOTB file upload control to add attachments to the list item. Upon save, the attachments are saved to the item. But before saving the list item with ...
Phani Kumar M's user avatar