Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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()&...
Ray's user avatar
  • 13
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 ...
Nas's user avatar
  • 69
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 ...
seaandtea's user avatar