Start Date and End Date Form Entry Restrictions?

10/07/21
Answered - Pending Review

Good Morning,


I know this is purely for cosmetic purposes in terms of putting the correct date in start and end.

However, I was wondering if there was a solution to this problem using logic tab in the form section.


My Users keep currently getting confused and putting there "End date" as the "Start Date" and the Start Date as the End date.. which is screwing up when I export to excel from Smartsheet. Is there anyway to restrict them or give them a message if the Start Date is before the End Date?


So if Start Date is "12/25/2021" and End Date is "12/24/2021" how can I get it to display " Your start date cannot be before your end date" or prevent them from doing this?


Thank you! :-)

Tags:

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @AusKee

    I hope you're well and safe!

    You could use the Form Logic feature only to show the Start Date until selected and then show the End Date.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

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

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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.