Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [column-validation]

The tag has no usage guidance.

0
votes
2answers
32 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
45 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
27 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
25 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
33 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
46 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
28 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
81 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
180 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
22 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
42 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
259 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
49 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
86 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
130 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 ...