Is possible to reference values of another row (item) in list Validation Settings conditional formula?

For example: I want to prevent the user to save a new item with same date of another existing item.

1 Answer 1


Unfortunately, No.

You cannot reference values of another row (list item) in list Validation settings conditional formula (or calculated column formula).

enter image description here

Source: Introduction to SharePoint formulas and functions

If you want unique value in column, across the list (for all users), you can "Enforce unique values" from column settings:

enter image description here

Update from comments:

Example of enforcing unique values on the list column:

User will see error message like below while saving the new list item when there is an existing list item with same column value:

enter image description here

  • What do you mean ? Can you give me an example ?
    – Damian
    Feb 26 at 14:56
  • Are you asking about the 2nd part in my answer, about having unique values in the column? Feb 26 at 15:00
  • Yeah, regarding the example that I mentioned before (with the prevention of saving) . Thank you .
    – Damian
    Feb 26 at 15:03
  • Check update answer with the screenshot Feb 26 at 15:18
  • 1
    Add the specific date column as index column, then set the specific date column Enforced unique column. Feb 27 at 9:26

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.