All Questions
Tagged with validation calculated-column-formula
40 questions
0
votes
1
answer
21
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. ...
1
vote
1
answer
21
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
738
views
Making required condition in SharePoint list dependent on another field
I have a SharePoint list with several choice, date, text and yes/no fields. I want to make some fields conditional on another field containing a certain word.
So for example, I have a field called '...
- 23
0
votes
1
answer
139
views
SharePoint Online Modern Form Conditional Formatting (Column Rules)
I am working on a SharePoint Online Modern Form solution using the OTB conditional formatting. There are three rules that I am trying to apply, here is the example.
Two Columns:
COL1 - Choice Field - ...
- 49
0
votes
1
answer
3k
views
Set field as mandatory if the field is dependent on another field
Can I set a field as mandatory if the field is dependent on the status?
Below is the form to insert information for a new plan. How to set Purpose of Visit field as mandatory.
If I use the below ...
- 27
1
vote
1
answer
114
views
How date can be dependent on status changing
I developed a travel plan list on SharePoint. In the plan, for travel, there are 3 drop-down stages:
Planned
Completed
Cancelled
But the issue is anyone can select the "Completed" status ...
- 27
1
vote
2
answers
217
views
Microsoft LISTS Validation Settings question
In my list I have 3 columns, one titled 'Review Status', one titled 'Type of System' and one titled 'Needed Information'.
I am trying to write a validation that says
If the Review Status equals ...
1
vote
1
answer
84
views
SharePoint Site column of type Single line of text with specific validation expression
I'm looking for a validation formula to validate a site column in SharePoint site and make it only accept only lower case English characters, numbers, and only hyphen, I tried below formula but it's ...
- 217
1
vote
1
answer
252
views
SharePoint List Validation Not Working
I have this list validation expression:
=IF([Enrolled], IF(ISBLANK([Email Address]), FALSE, TRUE), TRUE)
But its not triggering any validation. I also tried some simpler validation expressions:
=IF(...
- 11
0
votes
1
answer
41
views
Sharepoint validation list conditional
I need to write a list validation formula. I have a column named type of change that is numbers that is mandatory if other column dollars is filled.
Thank you
- 1
1
vote
1
answer
586
views
Validation on a list if date is not blank and Monday - Thursday
I have a form with about 10 fields. One of them is Start Date. I am trying to create a formula that will validate if a Start Date is selected and if the Start Date is Monday - Thursday.
In other words,...
- 13
1
vote
1
answer
440
views
Multiple sharepoint list date column validation in list settings
I am trying to add validation on multiple dates in SharePoint list.
Example: If end date is added by user the start date shall be mandatory. The start date shall not be greater than end date.
=IF(...
1
vote
1
answer
60
views
Validation in SharePoint List (IF, AND, OR)
I need:
If [estado]= "concluido" > turn into mandatory columns [Diagnostico Final] and [Atribuído a]
And:
If [estado]= "Executando Trabalho" or "em transito" or &...
1
vote
1
answer
177
views
Two formulas in validation settings
I am trying to add two formulas in validation settings but getting syntax errors.
I have created a leave request list in SharePoint. My requirements are below:
If Half Day(Yes/No column) is equal to ...
- 23
0
votes
1
answer
85
views
Need help with another sharepoint validation formula
I am trying to validate the Ticket Number field for certain task types and i am trying to validate the Manager email field for certain task types.
My fields are like this:
Task Type (Radio button ...
- 37
2
votes
1
answer
373
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
764
views
List Validation syntax error
I have a challenge with the List Validation process for a simple form. I need to check 2 fields: If [NPC Status] is "Passed" and [NPC End Date] greater or equal 2/24/2022.
=IF([NPC Status]=&...
- 13
2
votes
1
answer
17
views
SharePoint Validation Settings
I have a drop down with Not Started, In Progress, Completed, No Longer Needed as different options.
I want to require In Progress Comments to be filled in when In Progress is selected. When Completed ...
- 21
1
vote
1
answer
163
views
SharePoint 2013 Mandatory Column when Based on drop down on another column
I have a SharePoint 2013 list where I need to log Issues.
One of my column is labelled "Issue Status". Generally, I have REQUIRED field populated when the form is filed out and the "...
- 21
1
vote
3
answers
355
views
Calculated Column Yes/No based off 3 Yes/No columns
If column A, B & C all show yes then column D should also be yes
If column A, B or C shows no then column D should be no
Can somebody help me write a formula for this to use in a SharePoint ...
1
vote
2
answers
350
views
SharePoint list: Conditional required field - Hhow switch off
In my SharePoint list there are two columns: A and B (both of them are required).
Scenario: If user will input value in column A, he don't need fill column B.
And reverse, if the user enters the value ...
- 49
0
votes
2
answers
474
views
List Validation Formula not working
I need your help to fix my issue, basically what I want is when users select B from choice filed, the next column become mandatory.
Below formula doesn't work:
=IF([A]="B", [TEST] = " &...
- 605
0
votes
1
answer
4k
views
Validation Column Not Working
I have a Validation Setting column which seems not to be working with the formula =RTW>=StartDate and I get error:
'Something went Wrong'
However it works if I have the formula =RTW=>Today() ...
- 63
1
vote
1
answer
19
views
How can I set a special format in a column or leave the field blank
I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank.
I have already ...
- 11
1
vote
1
answer
1k
views
Column 1 and 2 are equal or the same then column 3 defaults to yes
I want to change a column to yes if two other columns are equal, so same title and report week.
So if report week column and title are the same, then duplicate entry is yes.
=IF[Report week][Title]<...
- 11
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
1
vote
1
answer
49
views
check tow fields values in sharepoint validation settings
I have a form to create a task and the user can edit it after manager approve it,
I don't want to allow the user to submit after approval if field [Task Status]="Waiting on someone else" or ...
- 13
1
vote
1
answer
282
views
Sharepoint 2013 List validation - two fields contain text
Pardon this newbie question on SharePoint list validation, I have been researching this for days
SharePoint 2013
SharePoint LIST validation since you cannot compare two fields in FIELD validation
Two ...
- 13
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
1
vote
1
answer
572
views
Column validation with multiple arguments
I have two columns that wish to validate on. Column A is a number field and Column B is a choice (drop-down) field. I wish to restrict the options that can be selected in Column B if the number ...
- 25
1
vote
0
answers
43
views
Sharepoint 2013 Form validation - I have 4 date fields I want to validate on. The first 2 are compulsory second 2 can be blank or filled in
I am having dificulty getting my validation formular to work.
Field Names:
DateAdded (first date) Expectedleave (second date) these are compulsory and the Expectedleave must be equal to or greater ...
0
votes
2
answers
49k
views
Validating dates in SharePoint so they cannot choose a date before today's date, how would I write that formula? [duplicate]
I am back at this form I have people fill out in SharePoint Designer and have a new small issue, here is my formula:
=AND([Requested Posting Date]>=[Date of Request]+1,IF([Date of Request]="New",[...
3
votes
2
answers
145
views
How can I validate number column
I have number column in my new form.
If user write here number, I need to validate if it is multiple of value 0,5.
For example 1 or 2,5.
I've tried formula for column validation:
= ?*0,5
but it ...
- 179
0
votes
2
answers
5k
views
Column Validation for day Monday OR Friday
I'm working with a date and time column and need a validation that returns true if the day of the week is Monday OR Friday. Users are not permitted to add an item on any other day of the week.
=TEXT([...
- 3
0
votes
1
answer
1k
views
How to specify a specific range of dates
I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how.
I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...
- 269
0
votes
1
answer
168
views
Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule
I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
- 1
0
votes
1
answer
125
views
Validate entire column with condition
I have a list that has a column which is an integer. Is it possible when selecting a number to validate if this number has already been chosen in the list.
For example
List
Title Order
...
- 162
0
votes
2
answers
3k
views
SharePoint Column Formula Validation
I need to check if a column (type Number) is an Integer (no decimal).
I added this formula to the list validation:
=mod([MyField],1)=0
But I get this error:
The formula contains a syntax error or ...
- 2,873
2
votes
2
answers
363
views
Date Format Modifcation in List
I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
- 21