Date Logic in Form

dpm1028

In forms it is not uncommon to have a Start and End date for any reason (mine is for PTO). It would be very helpful if there could be some logic added to Date fields to compare with other Date fields. In my case I need to add logic that prevents a user from entering an End Date that is prior to the Start Date. Today this does not exist.

John Bray

I could use another date format with the day in it, so only Tuesdays could be selected as an example.

It appears that this is not possible in forms now.

ker9

In the meantime, you could use a helper column with a formula that returns the day number:

=DAY(DATE@row)

Where DATE is the column name that contains your date.

结果:1 =周日,周一2 = 3 =周二,等等。

John Bray

我试图利用一种形式and sheet to track meeting requests on a set day. I adjusted the Timeline display to Months, Weeks, and Start Day to Tuesday, this will work for what I need currently. Though not as elegant as being able to select/restrict set days/dates directly utilizing the calendar on the form.

Thank You for the Suggestion!

_jacob

Currently, the DATE field allows us to enter a specific date -- however this date is almost impossible to preset to the current date without javascript or bookmark workarounds.

Idea 1: An option to easily set the prefill of DATE to (today).

Idea 2: Allow the use of dropdown boxes to store time in the DATE formula. This is a very popular future in SharePoint and makes migrating to Smartsheets slightly more annoying than it should be.

Manually entering time information formulates information incorrectly, it's also more prone to user error.

Thanks,

Jacob

Violeta_1

We have a form that asks users to select from a drop down their preferred day and time and their back up day and time. Right now I cannot prevent users from selecting the same day/time as their preferred and back up.

It would be nice if there was an advanced logic that we could add to the form that would hide the value in the drop down list that has already been selected by the user in another field. For example, in our form it would prevent users from selecting the value they already selected from their preferred day and time to their back up day and time in their form submission.

jacquedale

allow for an easy way to setup booking feature within the form. My field teams allow contractors to scheduled desired dates/times for inspections however I am having to build a complex work around instead of a simple booking addition that would eliminate options as they are selected.

jsquaredz

A typical scenario is having a start and end date. There are times where we want to limit the duration between the two. Would be great to have a validation that can be setup that will calculate against another date field and validate against a max or min difference. Also a validation for start date relative to the current date. so that a start date less than X days from submission is not allowed.

Trish Dillon

i have a form that needs to have dates checked and validated on the form that the date chosen is not a weekend or holiday.

would be nice to have criteria to allow or validate that is customized

OORF

In a Smartsheet form, having the ability to have a list of dates, but be able to apply logic to only show future dates, or dates within the next x time period.

Karinola84

To restrict users to enter an End Date in the past.