-
Reusing a form but want data collected to go to a new sheet.
How would I reuse a form but have the data collected on a sheet other than the original sheet?
-
Multiple Forms for a single sheet - Identifying the Submission source
Hi All, We have created a two forms from the one sheet and we can see in manage forms there are a different amount of respondents from one form vs the other. What we cant figure out is how to show the source of the response in the sheet? Can anyone help with this? Thanks in advance Steve
-
Calculations based on form field entries for data validation
I'm creating a form in which staff enter #s into each of several fields. They need to total to 100 (percent). Is there any way to at least show the total live in the form or, preferably, enforce that they add to 100?
-
Can data received from a form be sent to different sheets?
Hi everyone, I find Forms is a great feature to gather consistent data and then take actions. I wonder if there is a possibility that we can send data received from a form to different sheet? Now I think it is only possible for one source sheet. Many thanks, Dat
-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
-
Inserting Duplicate Fields Within A Form
Hello, I am currently working on a sheet that requires users to select documents from within a dropdown, and then answering whether or not they will be adopting said document. Since each document may have different answers pertaining to adoption, I can't allow users to select multiple documents at the same time. My…
-
Format form email?
Hello! Can the formatting of an email that is sent by a form be customized, or even changed? The email that is sent has all the form info of course but is incredibly difficult to read for the recipient. Thanks!
-
Custom message when form is disabled?
Is there a way to customize the message that is displayed when a form is disabled? I have a sheet I use for contest entries and disable the form when the date for submissions has passed. It would be great to be able to customize the message if the form is accessed once it is disabled. Any insights are appreciated! Thanks!
-
SmartSheet skips numeric values
Hello! I use a sheet that is filled by a form, I noticed that some times when I was trying to use the SUMIF function, some values were omite. I find out, that if I rewrite the value skipped directly in the sheet, the function doesn't skip the value. Someone knows what cause this problem or what can I do? Any help is…
-
Restrict Input on Web Form to Dollar format?
Is it possible to create a field on the web form that will enforce any entered number to be in the dollar format (dollars, cents) versus just text? The column in the referenced Smartsheet is set up to that format, but users may enter $100K... can the webform enforce $100,000 in this instance? I couldn't find any reference…
