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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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