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

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…