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

Questions tagged [column-validation]

Column Validation allows the developer or designer to define additional constraints or checks for user data entry in list/library metadata columns.

Filter by
Sorted by
Tagged with
2 votes
2 answers
32 views

Require column based on another column

I am trying to make it that my columns "Event location city" and "Event location country" are required ONLY if Event type is In person or Hybrid. Is this possible?
user111595's user avatar
1 vote
1 answer
15 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
0 votes
1 answer
74 views

SharePoint Validation: If Empty or Null

I need help with a validation formula in a SharePoint Text column where: column can be empty ( the default state when list is opened) column can be null (the state after a value is deleted) must be ...
ChasEpes's user avatar
  • 109
0 votes
0 answers
21 views

Online SharePoint Columns Validation in SharePoint list

I have two columns for validation. " Vehicle Model" and "Vehicle Registration Number" and are choice columns. I want the vehicles to be validated by the Vehicle Model when ...
Rashid  Edward Conteh's user avatar
0 votes
1 answer
330 views

Validate time field for 23:59 format in SharePoint Online list

I'm trying to add validation to a text column in an SPO list so that entered data only contains values from 00:00 to 23:59. I referred this article for a validation code which works fine. But it does ...
Robin Roy's user avatar
2 votes
1 answer
260 views

Need help with column validation on a single line of text field

I am looking to validate that my field always starts with the following text before allowing it to be saved "inc", "sctask", "prb", "chg", or "ritm". ...
drgaprilfool's user avatar
1 vote
1 answer
314 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
0 votes
2 answers
49 views

How to create a column validation that will not allow salaries higher than $15,000 on SharePoint 2013?

I am trying to create a Data Validation that will not allow salaries higher than $15,000 on SharePoint 2013. I can do this perfectly fine in Excel like this: but when it comes to SharePoint it is ...
getzucked's user avatar
1 vote
1 answer
67 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
0 votes
1 answer
1k views

Looking to trim leading and lagging spaces from Title column in a Sharepoint list

So I'm trying to integrate Power Automate into our SharePoint workflow to create a folder with the same value as the value inputted into the Title column of our SharePoint list. The flow failed today ...
Devin's user avatar
  • 1
1 vote
0 answers
48 views

Does column validation effectively disable all workflows?

I'm looking for confirmation that this is a problem with SharePoint in general and not just my farm, and to document this in the StackExchange knowledgebase. I also want to figure out, does this ...
Dean's user avatar
  • 11
0 votes
1 answer
232 views

Column Validation not working

I'm trying to put the following formula into column validation: [Title]="Job Request" When I save it, it gets replaced with: =Title="Job Request" and does not work properly. It ...
Brian's user avatar
  • 1
1 vote
1 answer
4k views

Formula to validate the column is not empty if a column contain a particular value

I need to add a column validation to my list. I have 4 columns. Status (Choice) Version OutCome (Choice) Effort If I choose Status as 'Completed', The other fields should not be blank.
vinil narayan's user avatar
0 votes
1 answer
58 views

When I edit a Site Column, the updates aren't propagating down to the list I'm using the Site Column in

When I edit Column Validation in a Site Column, it doesn't propagate down to the list I'm using the column in. Isn't that the point?
Gene R's user avatar
  • 115
0 votes
2 answers
29 views

Additional option in Column Validation

I have a a validation that only accepts a specific format of 6numbers followed by a dash and further 6 numbers as below: =IF(ISBLANK(FAQ),TRUE,AND(LEN(FAQ)=13,MID(FAQ,7,1)="-",ISNUMBER(MID(...
mtagliaferri's user avatar
0 votes
1 answer
124 views

SharePoint Calendar Validation - Time Limit

=AND(AND(CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,FALSE,FALSE),IF(OR(TEXT([Start Time],"hh:mm")="12:30",TEXT([Start Time],"hh:mm")="13:15",TEXT([...
seaandtea's user avatar
0 votes
1 answer
41 views

Complex SharePoint Calendar Validation [closed]

=CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE)
seaandtea's user avatar
1 vote
2 answers
679 views

How to create a calendar form with multiple column formatting?

I am a beginner of SharePoint. I want to create a calendar form to use it as a team members out of office info, a meeting request to a manager, etc. The form includes; Name, Title, Start/End Time and ...
Rachel's user avatar
  • 11
2 votes
1 answer
137 views

Add validation on numeric column when user fills control using coma

I need to add validation on a numeric column. An error should be when the user fills the control with a decimal number using a comma instead of a dot. I have a formula which looks like this: =AND(IF(...
Karolina's user avatar
1 vote
2 answers
198 views

Validation Upper case not working correctly

I am using SharePoint 2016 and I am trying to enter a validation for a single line text that must be 7 characters in length with a hyphen in position for (XXX-XXX). I have two issue, first I released ...
mtagliaferri's user avatar
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
1 answer
490 views

Text Column Validation: Numbers only, 5 numbers, a period, and 3 numbers

In my SharePoint list, I need a text column [ID] to validate as 5 numbers, a period, and then 3 numbers. Example: "15202.123" and I need help. :-) Thank you!
ChasEpes's user avatar
  • 109
0 votes
1 answer
181 views

How to insert multiple values into one column separated by semicolumn

I have a single line of text field titled 'NOTIFICATION NO' with the following column validation: =OR(LEN([NOTIFICATION NO.])=0,AND(LEN([NOTIFICATION NO.])=9,MID([NOTIFICATION NO.],1,3)="500"...
FRECEENA FRANCIS's user avatar
0 votes
2 answers
2k views

column validation in a SharePoint Online List based on the value of multiple

The below formula returns an error in SP online, how can I fix it? if( AND(ISBLANK([Project start date]),equals([Cash flow distribution], 'Unknown')),true, if( AND(NOT(ISBLANK([Project ...
Mohsen Sichani's user avatar
1 vote
2 answers
2k views

Date Column Validation - Check if Date is less than 10 days from Today

I have created a column named Departure Schedule and its type is `Date and Time. However, I need to check that the Departure Schedule should not be less than 10 days from Today(). Is it possible to ...
Jee Garin's user avatar
1 vote
2 answers
389 views

SharePoint Survey: Checking for duplicate response entries

I need to create a survey on SharePoint where the users will need to rank 13 unique items in order of importance. As such, I need to somehow enforce all response entries from a single person are ...
spicypumpkin's user avatar
2 votes
1 answer
173 views

How do I write validation statement to require a day of the week?

I have a field in a custom list called "WeekOf". I have a default statement that populates the date as the following Monday, but some people are entering for future weeks and then add a ...
ahowes's user avatar
  • 21
0 votes
1 answer
84 views

Validation setting for Date Sharepoint

I want to apply validation setting so that my "ActionDate" should be always greater than 2 year and 6 month. I can able to set greater then today but how to set it should greater then 2 year ...
kumar's user avatar
  • 139
0 votes
2 answers
640 views

Is there a way to remove white-space from the Text?

For example, If I give input text in the Column as - mo bi le pho ne. Then the data should be saved in the column as- mobilephone (it should remove all the white-spaces) Also, the Validation formula ...
user91339's user avatar
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
1 answer
86 views

Custom Validtion syntax for the IN operator for a column of SharePoint list

I am trying to find out how can I write a code to restrict a user to enter a value among a set of predefined values (i.e. IN Operator) in a column of a SharePoint list. My column name is "Asset type" ...
Mohsen Sichani's user avatar
0 votes
2 answers
747 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
626 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
1 vote
1 answer
122 views

How to validate a column based on the value in another column?

I'm trying to come up with a formula that could validate a column. I have a form in SharePoint to register parcel shipments. There's a column that contains a shipment code (values 1, 2, 3). If the ...
Benjamin's user avatar
0 votes
1 answer
800 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
615 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
1 vote
3 answers
1k views

What is actually the scripting name or the language name use in Sharepoint list column validation?

What is actually the scripting name or the language name use in Sharepoint list column validation? Is there any text or code editor available for the scripting?
Nas's user avatar
  • 59
1 vote
1 answer
24 views

multivalidation in sharepoint list [closed]

I am working on sharepoint 2016 and having issue in applying multiple validation between date column Column A should not be less then Column B Column F should not be less than Column C Column E ...
Rahul Aggarwal's user avatar
1 vote
1 answer
163 views

Column Validation AND OR - Prevent Save

I have a SharePoint list with Column Status and Impact. I need to validate If Status equals "Pending" or "Approved", then Impact can NOT equal "U". At this point I want the users to change their ...
Melissa C's user avatar
4 votes
1 answer
619 views

Column validation on a non required field

I would like to have validation on a column that IF you type in the field you have to use 19 letters. But if you leave the field blank you can still save. Right now I use this: =IF(LEN([column 1])=...
288088's user avatar
  • 129
0 votes
1 answer
32 views

Column validation user message pops up for millisecond

So I got this column validation: =[Sleep]>TODAY() And user message "NO". And it works, I cant put a date back in time, but the user message "NO" is just popping up for a millisecond, someone knows ...
288088's user avatar
  • 129
0 votes
1 answer
49 views

Problem with validatin settings "columns jumping around"

So I got my formula to work the way I want it to a point. Here is my formula (I guess its kinda bad, but it kinda works out). =IF(AND(Ärendetyp="LSP";Status="Tekniker klar");IF(AND([Ärende tilldelat]...
288088's user avatar
  • 129
1 vote
1 answer
263 views

Validation on column between 2 values

I am using SharePoint 2016. In a list, I created a column hostname of type single line of text. I would like to limit the values between r000xxx and r399xxx where (x= any letter). What's the right ...
ttb211's user avatar
  • 11
0 votes
1 answer
725 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
29 views

Field Level Validation - Require Non-blanks on Numerical Fields

I have a custom SP list with a handful of non-required numerical fields. I'd like to write a column validation rule for each that would force users to enter any value >=0. Our users will be using Data ...
Nerd Gorilla's user avatar
1 vote
1 answer
40 views

Restrict User's Choice in Datepicker

I want to allow my users to only select either the 14th or the 28th of any month when they make a selection. Is this possible?
Neoz's user avatar
  • 11
0 votes
1 answer
1k views

How to restrict users to upload .pdf and .zip only in Modern SharePoint Online Site (Document Library)

How we can restrict to users to upload only few files types in Document Library (SharePoint Online, Modern Communication Site). I have two libraries one can accept only .pdf and .zip and another can ...
Virendra Kumar's user avatar
1 vote
3 answers
2k views

Add more than one formula in SharePoint Column validation

I am struggling to add two formula together in SharePoint list column validation. For example : = formula 1 AND formula 2 (didn't work) ; = formula1,formula2(didn't work) Can anybody give some ...
BaxD's user avatar
  • 124
0 votes
1 answer
178 views

Column Validation only when item has a value

I have a list where I'd like to enforce that for one of my Single Line of Text fields, the user must enter a value with exactly 3 characters. However, the field is not required so I only want the ...
user3587336's user avatar
0 votes
2 answers
592 views

SharePoint 2013 - How do I save the value of a read-only or hidden field?

I'm trying to set a field in a list's edit form with a value after the user clicks "Save." Here's the catch: I don't want the field to be editable by the user (only JavaScript should set its value). ...
Clark's user avatar
  • 25