Date Dependency in a Form

Hello,

I have a form setup for vacation requests and tracking purposes. In the form the requestor has to input todays date, which automatically defualts to today's date, but we're having issues with the start and end dates. I would like default date to be dependent and automatically to at least update to the start date to reduce submissions with non corresponding dates like the attached.

Find more posts tagged with

Forms

Project Management

Comments

Schiff A.

Hello,

Currently default values are set statically and are not able to be dependent on other fields.

You can let our product team know that you'd like dependent default values in forms by clicking on the Submit Product Enhancement Request link on the right-side pane of Community pages.

Thanks!

Schiff

Smartsheet Support

scott.thompson23841

Can any checks or rules be put into a form to validate upon submission and display an error?

If SS can't, you would get much more flexibility by integrating with google forms or one of the other providers.

Schiff A.

Hello,

Smartsheet forms themselves can validate data using dropdown lists and can require fields.

Beyond that, you could use automated update requests to check submitted data and then send an update request to the submitter if there is invalid data.

You can also store Google Forms data in Smartsheet using Smartsheet Sync. See this article for more information about Google app integrations: https://help.smartsheet.com/articles/1850129-smartsheet-sync-add-on-for-google-forms

Thanks!

Schiff

Smartsheet Support

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…