-
Prefill Form with a Date Column
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would…
-
Form Default range
Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of range items can be highlighted red, that will be great. Also, If I can display the…
-
Is there a way to add logic to a statement in a form (not at field)?
I am trying to use Form Logic to display a statement that displays only if "Yes" is selected on a form field, without it being a form field that needs to be completed. For example, if "Yes" is selected, then I want a statement to display that says "Please contact your manager to discuss further". Is there any way to do…
-
Edit data in smartsheet using a form
Hi I have data entry from which is used by one group of people to punch in data. I have created the form for that which sits on a smartsheet. I want to use the same form to retrieve the data (row) in the same form, so that another group can either edit or fill in some other fields which were left blank. thanks for the…
-
Form Automation
Hi, Not sure if this can be done. I've created a form that I want to send to users. Ideally, one person would fill in the name of the project, then through automation, send the form on for other users to continue filling out (with the project name already filled out). Or have the person fill the name in the form…
-
Forms Automation
I have created a form and have set up an automation that sends the form link to a customer. When the customer opens the link from email the form is different than the form I created. It includes the customer email address as a drop down box and the customer can see other customer email addresses. Also includes a upload box…
-
Quality Control Record
Hi, I am trying to create a smartsheet to track the quality of a constructed panel. The constructed panel needs to be checked at certain points by different team members. The data needs to be stored to each individual panel. I have tried using forms to submit the data onto a sheet however if i want to add multiple columns…
-
Mobile forms link is requesting login/free trial even though security is not enabled.
Hello, I've created a form and have the security setting disabled so that anyone can submit, from anywhere. It works fine on desktop, but if trying to submit via mobile, it is sending users to an "explore what Smartsheet can do" landing page - requesting users to either try Smartsheet for free or login to an existing…
-
How to auto-populate hidden values for forms?
Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell, but I am having trouble with this. The other issue is, unless they type what we have…
-
Is it possible to export a sheet as forms?
We often need to publish a report pulling data from a selection of columns, for a single row, sequentially on a page, and then the next row, etc (I.e. laid out like a document, not a spreadsheet). We currently use the Smartsheet add-on in google docs to do this, but it is frustrating and time consuming. Essentially what we…