Date as a Column Property on a Form: Any Way To Get It To Not Show Dates In The Past?

Sally Wico

Employees use a link to a Smartsheet Form to report their absence. This form contains a "Date" field for the date of their absence. I don't want them to have the option to select a date in the past. Is there any way to make past dates "lock out" so they cannot be selected?

Thanks!

Heather Duff

@Sally Wico I don't think so (yet - though it would be good to make as a feature request!). However, you could at least set it up with a heading/description error message using conditional logic where it appears if the date is before today.

Heather Duff

@Sally Wico You're welcome. It's not foolproof, but at least if the majority of the people filling out the form will read a message that pops up, it could cut back on the back-and-forth.

Heather Duff

@Sally Wico I don't think so (yet - though it would be good to make as a feature request!). However, you could at least set it up with a heading/description error message using conditional logic where it appears if the date is before today.

Sally Wico

I love the suggestion, Heather! Thanks!

Heather Duff

@Sally Wico You're welcome. It's not foolproof, but at least if the majority of the people filling out the form will read a message that pops up, it could cut back on the back-and-forth.