Questions tagged [column-validation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
3answers
33 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
25 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 ...
1
vote
2answers
52 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
28 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
42 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
25 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
42 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 ...
2
votes
2answers
71 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
95 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
33 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
42 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
54 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
62 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
175 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
478 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
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
80 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
372 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
65 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
149 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
193 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 ...