All Questions
3 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
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
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