Form - Restrict input of a past date

Manuel Chowrimootoo

Hi,

I am re-opening this question to know if any updates have been made since?

The question is related to the Smartsheet Form, on having an option to restrict a sender from being able to enter a past date in a form.

Related discussion open a few years ago in this question 'Web Form - Disallow Past Dates?'.

Thanks,

Manuel

Andrée Starå

Hi @Manuel Chowrimootoo

Unfortunately, it's still not possible, but it's an excellent idea!

Edit. Maybe it is by using the Conditional Logic.?

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Manuel Chowrimootoo

Excellent!

You're more than welcome!

As a possible workaround, you could use the logic to trigger when the date is before today and then show another column with a message that they need to select another date.

Make sense?

Would that work/help?

Andrée Starå

Hi @Manuel Chowrimootoo

Unfortunately, it's still not possible, but it's an excellent idea!

Edit. Maybe it is by using the Conditional Logic.?

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Manuel Chowrimootoo

Hi Andree,

Thanks for your response.

I will submit this enhancement proposition.

Andrée Starå

@Manuel Chowrimootoo

Excellent!

You're more than welcome!

As a possible workaround, you could use the logic to trigger when the date is before today and then show another column with a message that they need to select another date.

Make sense?

Would that work/help?

Manuel Chowrimootoo

Hi Andree,

Thanks for the workaround suggestion on the dates!

I added it, it provides a good way to capture the attention of the requester on this element.

Manuel

Andrée Starå

@Manuel Chowrimootoo

Excellent!

Happy to help!

JBG

@Andrée Starå if I understand you correct. Create another column called "Date Error". In this column add the formula to show an error when the date is before today (if date1<today,Ërror message",""). Display this column on the form.

I have a pro license, and when doing this the field on the form is blank.