Sign in to submit new ideas and vote
Get Started

Date Logic in Form

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.

27 votes

On Wishlist · Last Updated

This is a terrific suggestion. We're working to provide collaboration guardrails that facilitate high-quality communication and leveraging existing context fits neatly into that construct. If we believe we can make this idea a reality, we'll plan to update the status here.


  • 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
    ker9 ✭✭✭✭✭✭
    edited 04/11/23

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


    Where DATE is the column name that contains your date.

    Results: 1=Sunday, 2=Monday, 3=Tuesday, etc.

  • John Bray
    John Bray
    edited 04/11/23

    I was attempting to utilize a form 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
    _jacob ✭✭
    edited 02/01/23

    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.



  • 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
    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
    edited 03/10/23

    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
    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
    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.

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