-
Form on mobile view only half visible?
Our form is only half visible when someone tries to fill it out on their phone. Is this a problem with our website or the Smartsheet form?
-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…
-
Generating values that can be referenced in a drop-down
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fills out a form that creates a new line with an auto-generated "Request Number" If the form has a "Build" in the "Request…
-
Display results of a column formula on a form or response.
I have a simple form that allows users to answer yes/no questions with a checkbox. On the SS I have a formula column which sums the count of the yes answers and gives a score. I would like the users to see that score on the form either as they fill it out, or once they submit in the confirmation message or in the email…
-
Contacts in a Form
Hi I'm working on a submission form but, I'm struggling with the contact columns. The use case is that a file review will be done on any one of over a 1,000 lawyers the compliance officer completing the file review needs to enter the lawyer and their supervisors name in the form so, that reminders can be sent to complete…
-
How to embed a calendar to a Form
Hi , We are using Smartsheet form to sign up for move pack appointments. How can I embed a calendar into a sign up form? I have 9 days and 6 timeslots each day. I am using CountIF formula to alert when a cap of 9 sign-ups reached. I am trying to find a better way to manage an hourly sign-up capacity. If I can show the sign…
-
Form Response Validation
How can I validate the format of responses? For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format. Also, is there any way to validate an email address?
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
-
Form Dropdown Select and Quantity
Hello, I am trying to create a form where users can select a product from a dropdown and enter a quantity. e.g. the category is blue t-shirts, the dropdown are sizes (S,M,L) and users can select S and enter in 5 for quantity. I would also like users to be able to make multiple selections each with quantities from the same…
-
Hyperlink in Help Text
Hi everyone, I am creating a form in smartsheet and was hoping to create a hyperlink in the help text. It says here that we can include hyperlinks but every time I press right-click the option to do so doesn't seem to appear.
