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


Title Order

Item1 1

Item2 2

I create a new list item, select '2' for the Order item, and SharePoint kicks back saying 'Please select an Order number which does not exist'

1 Answer 1


You can in the column settings on the list mark the field with "Enforce unique values", that way each entry must be unique!

enter image description here

More, and the above image: http://adicodes.com/column-validations-and-list-validations-in-sharepoint-2010/

  • The list has a couple of folders in it. Is it possible to make it unique per folder? Commented May 29, 2014 at 14:53
  • No it is not, not without attaching some form of workflow or EventReceiver Commented May 29, 2014 at 15:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.