-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
Merged: Save and continue form submission
This discussion has been merged.
-
HUGE ISSUE WITH SMARTSHEET INTAKE FORMS!
HI EVERYONE! PLEASE NOTE THAT THIS IS A HUGE ISSUE IN THE SMARTSHEET FORMS! Using the Form logic, I have kept some "required" field hidden. But DESPITE these fields being hidden, my end users are able to click the SUBMIT button and submit the form! How can we submit a form without filling in ALL its mandatory fields?? I AM…
-
Predict or set which row a form writes to
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…
-
Forms - Previewing (validating) attachments before submitting the form
When users are utilizing a form, and they append an attachment to the form, we request the ability to preview or validate the attachment before they submit the form. For example, on email after you attach a file, you're able to open the attachment to be certain that was the intended file to submit.
-
Merged: Forms for Multi-Row Submissions
This discussion has been merged.
-
Form Element formatting
When you have a form that handles several different zones- and you want those zones divided visually, the divider is a quick and simple method to do that. However, it's such a light line it does get lost. Having the ability to use a thicker line, or different color would be extremely helpful. Today, we use a Heading...…
-
Easy search form , no login request
i have a table data : student, class register , certificate request, date open and expirer time it will very helpful if smartsheet form have feature : if student just select their name and it will auto show the class available to register, time start/time end also my team, warehouse - also have same question that : they…
-
Emailing attachments without links to sheet
Hi there. Somewhat tech savvy here, but my expertise is in professional development, specifically in healthcare, and I'm falling short of figuring this out on my own. Here is a little background info. I issue a certificate of continuing education following most of the classes I teach. I have created an evaluation form and…
-
Save As New on Form not working
Hi, I created a form which I now need to duplicate in order to tweak it / modify it to create a different form. I hit "Save as New" or even "Save as Template" and it gives me an error saying that Smartsheet is having trouble right now. I tried it on another form and it worked, but on this form, even if I remove most of the…