I've created an approval workflow but I want to be able to restrict items from being submitted if it misses a deadline date?

Sorry if that doesn't make sense!


You can create a Column Validation to submit your form in case the formula is valid


  • Open List Settings.
  • below Columns > Click on your column (Due Date) to edit it
  • At Column Validation > add your formula as you prefer.


You want to submit the form, in case the due date is greater than today! , so the formula would be

=[Due Date] > today()

enter image description here


When you try to set [Due Date] less than Today, The form will not be submitted and you will get the User Message that you have set in the Column validation

enter image description here

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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