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

Options

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.


Answers

  • Emilio Wright
    Emilio Wright ✭✭✭✭✭
    Options

    @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 ✭✭✭✭✭
    Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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!

    Cheers,

    Genevieve

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭
    Options

    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!