-
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…
-
Restricting Text/Number Columns to a Format
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful to have, especially with the amount of forms that I, along with my Smartsheet…
-
Receive an emailed attachment on submission of form.
Im creating a shipping request sheet and have created a form so people can submit address details etc . Once submitted this will go to a department for approval. I would also like an attachment to be sent with the email . For example, the email goes to the shipping department for approval and a standard packing list is…
-
Can the selections from a dropdown multi-select question in a form be used to auto create columns?
If I have a question in a project intake form that allows for individuals to multi-select all of the rooms that will be a part of a project can I then in turn use those selections to automatically create columns in the worksheet that corresponds to the rooms that were selected? Thank you for taking the time and any…
