Need available dates displayed to be at least 7 days after Request date


I have a form. User enters request date. I want dates that display in the due date column that they can select to be a minimum of 7 days after the due date.


  • Emilio Wright
    Emilio Wright ✭✭✭✭✭

    @Becky Wilson I don't believe that Forms have that type of logic yet. If you have an idea of what the Due Date might be, once they submit their form you could use a helper column to add more days to the Due Date they entered. I usually do this on my forms.

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭

    Emilio Wright. Thanks for your response. hoping there is a solution.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Becky Wilson

    Emilio is correct, there currently isn't a way of restricting dates in a Date field in a form. What I would personally do in this instance is have the second field be a dropdown selection of numbers... for example:

    "How many days from today is this due?"

    With set numbers, such as 7, 10, 14, etc. Then in your sheet you can use a simple formula to add those days to the Request date to find the Due date:

    =[Request Date]@row + Days@row

    See: Use Formulas to Perform Calculations With Dates

    An alternative will be to keep the form as-is but add helper text above the second date saying that the minimum due date is 1 week out, noting that form submissions with earlier due dates will immediately be rejected. Then you could use a formula in the sheet to check the number of days between dates and automatically check a flag if the due date is too soon, triggering an Update Request workflow to the original form submitter to choose a different date.

    Let me know if this makes sense or if you'd like to see screen picture examples of either scenario!



  • Becky Wilson
    Becky Wilson ✭✭✭✭✭

    Thanks Genevieve. We've already got helper text. Not necessarily being followed. I like the idea of just providing a drop down list of # of days.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!