-
Prefill a form response from another sheet
I have a project tracker sheet and am trying to set up a flow to send a survey via a form once the status of the project is changed to complete. I would like the survey to prefill with the project name from the source sheet, of the project that was changed to closed. Is this possible? The form results (survey results)…
-
Compare Pre and Post Survey Results
I have a pre class survey and a post class survey. The surveys include both likert scale and fill in the blank questions. I would like to compare the data from the pre class survey to the post class survey in order to analyze and create metrics on improvement. Any ideas on how to actualize this?
-
Survey having sub questions inter-linked with the main question.
Hello Smartsheet Community, New Year Greetings to all! Can anybody help me with this? I have a survey question with sub-questions. Each sub-question has multiple choices. Please see the attached image below for reference. Is there any way by which I can link the sub-questions with the main question? I want a way wherein if…
-
Formula to reference sheet auto ticket # with survey form link so that ticket id# follows process
Hi! I was viewing How to Build a Ticket Intake Process That Actually Works - YouTube and at 9:45 minutes in, the presenter references a formula that will point to the ticket number on the intake sheet, connect it with the link to a survey, so that when the customer completes the survey and their info is input into the…
-
Survey Reporting
I have created a survey and activated a form which is now being completed. The data is coming back into the sheet, but now I need to report on that data and hopefully build a dashboard for all of it. How can I report on qualitative information? The choices are correct or incorrect for each of 25 questions across maybe 80…
-
Remove "work" and company title/#employees from free account registration form
The form/survey function is great, especially when adding a login. However, we cannot use a survey for individual use. For example, we want customers to share information with us via a form survey. They are individuals not affiliated with a company. To register, Smartsheet wants a "work email" then asks for their title and…
-
Merged: Adding Images to Fields Smartsheet Forms
This discussion has been merged.
-
ampersand symbol in Smartsheet form emails
When collaborating and/or leveraging forms with email confirmation, if/when the title of the form contains the ampersand symbol, it errors when the email is received by the end user. An enhancement can be made to enable the product to be able to send emails from Smartsheet without a character error.
-
Graphing Non-Numeric values
I would love to be able to graph non-numeric values. We recently sent a survey to our staff where many answers were selected from a list of dropdown options. In order to clearly display the results I was looking to create pie charts showing the responses to individual questions and was unable to do so without creating a…
