All Questions
10 questions
1
vote
1
answer
32
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" ...
- 46.4k
1
vote
1
answer
39
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 ...
- 46.4k
0
votes
0
answers
24
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 ...
- 46.4k
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()&...
- 46.4k
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(...
0
votes
1
answer
225
views
Making a Date field required in case the use select In-progress from a choice field using list validation formula
I have a SharePoint online custom list which contains 2 columns:
StartDate of type Date Time
Status of type Choice field which have values such as Open, In-Progress, Closed.
Now I want to write a ...
- 46.4k
0
votes
1
answer
334
views
Conditional Required Field in SharePoint Library
I know how I can make the conditional formatting based on one selection, but I have an issue with multiple selections.
I have a City dropdown column with three options: Test, Test1, Test3. My other ...
- 46.4k
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 ...
- 2,742
0
votes
1
answer
2k
views
Validation user message not showing
I have a formula in List settings-> validation settings.
The formula validates correctly. The user message I entered does not display, it displays its own message below which is
Error: The ...
- 4,592
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 ...
- 46.4k