Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Date validation on Web Form

    ✭✭
    edited 12/09/19 in Formulas and Functions

    Is there a way to validate a date before submitting a form. 

    The Use-case is: 

    We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; so, they can't select an Event day within a week, before they submit the form.

    Thanks

    J

     

    Tags:
    · Share on FacebookShare on Twitter

    Comments

    • ✭✭✭✭✭✭

      Hi,

      Just to be clear, you would like to know if it's possible to validate the Event Request Date (Date field) in your web form to ensure that the end client cannot select a date that is within the next 7 days?

      If so, then the answer is unfortunately no. You could setup validation in the underlying sheet to notify you (and them), but there are no in-form validations or error messages available beyond the * required option.

      Kind regards,

      Chris McKay

      · Share on FacebookShare on Twitter
    • ✭✭

      Thanks for the clarification chris,

      Regards

      J

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions