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
0
votes
1answer
32 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 ...
0
votes
2answers
34 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 ...
0
votes
1answer
37 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: ...
0
votes
1answer
30 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" ...
0
votes
2answers
31 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) ...
0
votes
2answers
37 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 ...
1
vote
1answer
26 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 ...
0
votes
1answer
15 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 ...
1
vote
2answers
28 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 ...
1
vote
3answers
44 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?
1
vote
1answer
22 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 ...
0
votes
0answers
17 views

Calculated Column Validation Rule

I am looking at having a workflow to direct emails to the relevant department in accordance to the date of the request and the current schedule, the workflow is not the issue, but the calculated value ...
1
vote
1answer
33 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 ...
4
votes
1answer
189 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])=...
0
votes
1answer
20 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 ...
0
votes
1answer
46 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]...
1
vote
1answer
29 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 ...
0
votes
1answer
194 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 ...
1
vote
1answer
23 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 ...
1
vote
1answer
19 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?
0
votes
1answer
45 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 ...
1
vote
3answers
172 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 ...
0
votes
1answer
44 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 ...
0
votes
2answers
158 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). ...
0
votes
2answers
37 views

How to add two different formulas in column validation SharePoint

Need to restrict the user from entering special characters and to make the input length equals to 24 i.e the user can enter only alphabets and numbers of length 24.
0
votes
2answers
184 views

how to set the minimum length of a single line text in sharepoint online?

I have already set the maximum length, but now I need the user to enter not less than a certain amount This is the script I'm using : function PreSaveAction() { var control = getElementByID("IBAN(24 ...
0
votes
1answer
37 views

how to make a validation in sharepoint online that accepts only alphabets?

I need sharepoint online column to accept only alphabets. It should not contain any numeric or special values.
0
votes
2answers
83 views

Date validation to specific year for list Column in view

I've got a date column in a view and I'm using a validation formula: =IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE) So that users can only insert date within the year 2018. I always get an ...
1
vote
2answers
141 views

Column Validation check passes on Create but fails on Edit

I'm trying to validate that a month column is within 30 days of the create date in SharePoint online using the validation below: =AND([Start Month]<(Created+30),[Start Month]>(Created-30)) ...
0
votes
2answers
1k views

SharePoint 2013 How to make column validation check for a specific pattern?

I'm trying to create a record repository that will allow a single user the ability to manage uploaded documents based on a record disposal rule system. I need a column to validate that the uploaded ...
1
vote
1answer
137 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 ...
2
votes
1answer
181 views

SharePoint 2013 - Validate Date Columns that allow for blanks

I have a SharePoint list with three date columns, Start Date, Due Date and Extended Due Date. I need to have validation set so that the Due Date is no later than 14 days from the start date and the ...
1
vote
1answer
80 views

SharePoint 2013 Column Validation override for site owners

I have a list where user's can't edit a column if =[Delivery Date/Time]>(TODAY()+5) I have this validation on Delivery Date/Time column. I need admin/site owner needs to edit the list no ...
0
votes
1answer
173 views

Verify Date Selected Is atleast 3 Business Days Away

We have a SharePoint site that we use to schedule customer appointments. These appointments need to be scheduled on a weekday and need to be at least three business days away, but no more than 45 ...
1
vote
1answer
377 views

SharePoint Online Multiline text field form validation

I need a way to have form validation for multiline text fields when submitting a new record. I know characters like % are not legal characters but I need to be able to verify a multiline text field ...
0
votes
2answers
17 views

What validation code should I use such that if any Column entry is changed it shows an error ?

I'm basically trying to keep 5 columns of my list locked(uneditable) while the last column editable. I'm a beginner and thought this would be the easiest way to achieve this. Do kindly suggest any ...
0
votes
3answers
1k views

Single line of text - Numerical characters only

I have a single line of text column in my list called "Invoice Number" which only needs to contain numeric characters (0-9). I have attempted using column validation with =ISNUMBER([Invoice Number]+...
0
votes
1answer
24 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
144 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 ...
1
vote
1answer
748 views

Validation of Choice/Checkboxes Column to require Date Fields

We have a Travel Reason Choice/Checkboxes (allow multiple selections) column with values: Conference Customer Visit Site Visit Summit Training We also have date fields for each of these travel ...
0
votes
2answers
185 views

I'm trying to figure out how to add two validation rules to One SharePoint list

I'm trying to figure out how to add two validation rules to One SharePoint list. If the user selects 'Risk' from the 'Risk/Issue?' column, then they must not leave the 'Risk Mitigation Plan' field ...
-1
votes
1answer
268 views

How to indicate a blank space in Column Validation?

I have a column called Machine #. There is a space between Machine and the # symbol. I think the space might be causing an issue - Sharepoint does not seem to like having a space in the Column ...
0
votes
0answers
338 views

Column validation - can the column name contain special characters?

I have a column called Machine #. It is a Single line of text. I would like it to be in this format: Mxxxxx - all the 'x digits' are numerical. The first item should be called M00001. I would like ...