All Questions
Tagged with validation column-validation
23 questions
1
vote
1
answer
16
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()&...
- 13
0
votes
1
answer
438
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 ...
- 29
2
votes
1
answer
372
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".
...
- 37
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.
0
votes
1
answer
144
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([...
- 71
0
votes
1
answer
41
views
Complex SharePoint Calendar Validation [closed]
=CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,TRUE,FALSE)
- 71
0
votes
1
answer
226
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 ...
- 71
1
vote
2
answers
417
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 ...
- 111
2
votes
1
answer
187
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 ...
- 21
0
votes
1
answer
89
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 ...
- 149
0
votes
1
answer
90
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" ...
- 445
0
votes
2
answers
749
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 ...
- 69
1
vote
1
answer
128
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 ...
- 11
1
vote
1
answer
25
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 ...
1
vote
1
answer
168
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 ...
- 23
4
votes
1
answer
697
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])=...
- 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]...
- 129
1
vote
1
answer
288
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 ...
- 11
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 ...
- 25
0
votes
1
answer
195
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 ...
- 97
0
votes
2
answers
638
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).
...
- 25
3
votes
1
answer
198
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 ...
- 155
0
votes
2
answers
539
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 ...
- 3