-
Any plans to allow more than one upload field on a form?
Multiple upload fields would be helpful when specific documents are required to make a form submission complete. Right now, we have to list all the required documents and hope the user will read and follow the directions. Even if we require the field, they will only get an error message if they don't upload anything. (But…
-
How can I stop my Sheet Summary from changing the location of a cell when form data comes in?
I am creating an inventory form that populates data into a sheet on "Top of Sheet". I want to create a summary sheet that reflects how much of an item we need vs what we have entered on the count (via the form). My issue is, whenever a form gets filled out, it also shifts the cell I am trying to reference down. I want it…
-
Why can't I update a row with a Form?
I'd like to allow users to update information in a row via a Form. I like the user interface of the Forms and would prefer to keep users away from the spreadsheet. I know about locking information in the spreadsheet and that is not what I want to do. Our spreadsheet has a large number of columns and I want the user…
-
Employee Fit Testing Tracking
I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…
-
Form value of 1 in percentage column captured as 1% not 100%
I have a form that captures data in a column with percentage formatting applied. If a decimal value is selected such as .5 the data is properly captured in the sheet at 50%, but if 1 is selected it is captured ad 1%, not 100%. I've tried to change the value to 1.0 and 1 and the behavior is the same. In the sheet itself if…
-
Free Webinar: Forms Best Practices
Join us January 13th for our webinar "Forms Best Practices." In this webinar, you’ll learn best practices for creating, customizing, and sharing Smartsheet forms to collect and capture data. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to still register and we will…
-
Restricting Number Format in Forms
Is it possible to restrict the number format of form entries for text/number fields? I have some fields which are formatted for currency in the sheet, but the form will permit text to be entered in these fields. I see restriction for Date/Time, Dropdown, Contact List, and Checkbox, but not for the broader Text/Number…
-
Form Text Color Customization?
Does anyone know if there is any way to get the description text/font in a form with a picture to stay white? During the Engage conference, they presented the new form customizations, and it has an image with white text, but I can’t find any options to modify the text color in the settings. Any guidance you can find is…
-
How to I "not format" a number in a form?
One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to…
-
Smartsheet forms with text formatting
Hello. Is there an option to allow text formatting/editing (such as bullet points, bolding, italics, hyperlinks) in a form linked to a smartsheet? I have a column in a sheet named description, which I would like users to give a comprehensive description using the Form. Ideally similar to the formatting options I see within…