-
Creating a Workflow that Auto-populates a Form/Sheet
Hello, I was wondering if it is possible to create a workflow that once submitted and approved would auto-populate a Sheet or Form. Currently we use Support Central to capture associates Name and unique identifier. Once the workflow is approved the end user manually types in the requester's information from the workflow…
-
Auto Created Date - Historic Data
Hi, Just started using Smartsheet and I've got to admit, I am impressed. I have a form, when the user submits data in the form, the timestamp is captured for when it is created. The problem is, I have existing data I want to copy in which gets deleted when I change the column to autonumber - Created Date. Best solution…
-
Smartsheet Forms
Hi Team, I have created a Smartsheet form basically a survey, is there a way to capture who all have sent the survey to whom? we are using the email feature while sending the survey, as of now it only captures the filled responses, I want to find out , how many surveys have we sent and how many have responded.
-
Open Update Form - Restrict certain values from editing
Hi When you "Request an Update" in a workflow and the email is received by the intended party, is there a way to restrict which of the form responses they can edit when they're taken to the data grid? Currently they can amend everything that is in the grid but I only want them to be able to edit 2 new columns with their…
-
Forms - I am creating a form for a different cohort of students
I was wondering what happens with smartsheet if the same student submits a second application? Will it over write their existing application - eg if a student is in year 1 now and submits the form, and then lodges the form again , when they are in their year 2, will it overwrite the previous records submitted in year 1?…
-
Resize and format fields in forms
Is there an option to resize/ format (i.e., change color of the labels) in forms.
-
Is there a way to adjust the size of the text input field on a form?
Is there a way to adjust the size of the text input field on a form? Similar to the "paragraph" option in Google Forms.
-
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?