So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is:

=[Date Required]>TODAY()

This works well however I am running into an issue. If the department is updating a List item after the Future Date it will still provide an error. Is there a formula to use when the column validation can only be active when a new item is being created and not edited?

Thank you

1 Answer 1


Don't validate at the column. Validate on the whole item from the list settings menu, look for Validate Settings. Set your validation

=[Date Required]>[Created]

Source- https://www.premierpointsolutions.com/training/help-and-how-to-articles/how-to-validate-a-due-date-in-a-sharepoint-2010-list/

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.