-
Survey Results from Form to Dashboard Chart
Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered…
-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
How to copy form to create its new a bit different version
Dear All, I created a form in Smartsheet that is quite complex and I would like to create similar version of the same form but with some additional options to see what version will be better for my needs. As I don't want to start from scratch with this new version of the form, is it possible to copy ma first form and just…
-
How to copy questions when designing a form
Dear All, Do you know an option how to copy questions when designing Smartsheet form? I need to use several sets of the same questions with some minor changes and it would be great to just copy them than designing them from the scratch ... If such option exists and you know it, please let me know. Thank you!
-
Re-open Partially Completed Form
Hi all, We have a sheet that collects information about our accounts. Our contracts team enters some of the data via a form when they hand it off to our accountants. However, they don't always have all the information at the same time, and some would prefer to enter it piecemeal rather than needing to dig it all back out…
-
How to share a form after it is filled partially?
The form first needs to be filled partially and then shared to others to complete the rest of the form using the information previously submitted. The previous information filled shouldn't be made editable to the next user of the form. Is that possible? In the attachment, I want first four fields to be filled by me and the…
-
The default value set up in the form creation not working consistently
The default value set up in the form creation does not always populate cell when new rows added. Multiple grid columns in a single record have dropdown list columns using "N/A" as default value set up in the form creation, unless of course another value is selected. When the new row adds, some columns have blank cells…
-
COUNTIFS Function of # of Values Used in a Median Calculation for Metric Sheet
I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1))) I now want to calculate in a adjacent column the total…
-
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.
-
Date format reverting to US settings in form builder (I'm in NZ) - but not for all forms
Is anyone else having this issue? The date format is showing as US format (MM/DD/YYYY) in my form builder, despite my settings being set to NZ (DD/MM/YYYY). This is the first time it's happened, and weirdly, not for all forms for the sheet - just for a couple. Currently they're set as 'hidden' however is rather confusing…
