Questions tagged [validation]
Validation checks that the product design satisfies or fits the intended usage (high-level checking), i.e., the software meets the user requirement. This is done through dynamic testing and other forms of review.
439 questions
0
votes
0
answers
4
views
Prevent overlapping meetings in SharePoint online
Traditionally, I've used a JavaScript solution for preventing overlapping meetings in SharePoint on-prem but my organization is considering moving over to online soon(TM) in an environment without ...
- 1
0
votes
1
answer
17
views
RIGHT() in the validation section doesn't work
The formula is very simple :
=RIGHT([WHO], 3)="com"
And it tells me something like "The formula has a syntax error or is not supported", while in the documentation it clearly ...
0
votes
1
answer
72
views
MS Lists Validation Setting - how to create a formula
I am using =[FAY Date<=[Clearance Date] and is working but I do not know how to include [FAY Date<=[Contract End].
How do I combine both into one formula to use in MS List Validation Setting. ...
0
votes
1
answer
31
views
Need help with validation formula for document list in SharePoint list
I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to ...
1
vote
1
answer
42
views
Need assistance with creating nested IF statements in a AND statement
I have a nested IF statement, in an AND statement. The IF statement ensures that IF an "Approval Date" is entered, a value must be entered in the "Total Budget Amount Approved" ...
- 27
1
vote
1
answer
272
views
If one column is not empty, require value in another column
I am seeking SharePoint List Formula that requires an entry in one column, if another column is not empty.
For example, I have a column titled "Approval Date". If an approval date is entered ...
- 27
0
votes
0
answers
19
views
Validation formula conflict
In a particular column (DateRangeofReport) of a Sharepoint list I have a validation formula that ensures the input is entered consistently. Additionally, the input is optional, established by ...
- 1
1
vote
1
answer
83
views
SharePoint / Teams Date Column Restriction using Validation Syntax Question
I have two date columns in a SharePoint List. I am trying to figure out the proper syntax for use in the Validation box.
For the first, I want to restrict the date entered to only accept today's date ...
- 11
1
vote
1
answer
463
views
List Column Validation dependant on another column
I am using a Microsoft List for employees to request their leave (annual / sick leave).
I have a column called 'Leave Start Date' where they enter the start date of their leave. It currently has a ...
- 11
1
vote
1
answer
372
views
Formula to compare two date fields in SharePoint Lists
I have two date fields, not time stamp, in SharePoint that I want to display an error if one date is less than or equal to the other date field.
I'm not looking to calculate anything, just a simple ...
0
votes
0
answers
39
views
My list validation formula does not work on choice column
I have a SharePoint list with choice columns. I want to set a validation rule that says if Column A = "Yes" and Column B is set to "No" then it should error.
The idea is that when ...
- 1
1
vote
1
answer
142
views
Reference value of another row (item) in list Validation Settings conditional formula
Is possible to reference values of another row (item) in list Validation Settings conditional formula?
For example: I want to prevent the user to save a new item with same date of another existing ...
- 11
0
votes
1
answer
156
views
Multiple User Messages on list Validation Settings
Is there any OOB way to display different user message per validation?
- 11
1
vote
1
answer
51
views
Validate an entry is within a range
Any help with this would be really appreciated!
I have 2 columns both of type number (OrigDensity and TestDensity). I would like to validate as a user inputs TestDensity it must be +/- 0.05 of ...
- 11
1
vote
1
answer
196
views
SharePoint text field user should able to enter 6-digit alphanumeric characters only [closed]
SharePoint text field user should be able to enter 6-digit alphanumeric characters only.
- 11