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
22 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
15 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
39 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
22 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
54 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
18 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
17 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
19 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
44 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
31 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
75 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
31 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
61 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
26 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
47 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
105 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
581 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
64 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
71 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
63 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
117 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
253 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
754 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
115 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
518 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
114 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
197 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
268 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 ...