-
How to create a survey that will track who has responded?
I need to survey a group of people and we require a 100% response rate. If I just send a link to a survey form out, I can't see who has not responded. I have figured out that I can load the names of the survey pool and use an automated update request as my survey, but the update form is extremely limited in formatting…
-
Can I conditionally expose a form field based on an earlier entry?
Okay, first attempt at explaining what I want to do.... I have a sheet where I track items (rows) with a multitude of attributes (columns). It's fairly unwieldy so I wanted to provide Editors with a form to submit new items. Current Form: User enters Title and Description (text columns 1 and 2), selects the Category from a…
-
When using a form for input, can I add multiple rows?
I am using a form to input 'New Items to be added to the POS'. Process: a form is filled out by C-Store associates when a new vendor order comes in and some of the merchandise is new and not in our POS (This means that the register has no price for the new merchandies). The form is a way to alert Accounting to add the new…
-
Can Smartsheet have a Status Form?
We recently rolled out a support form where users key in their requirements for a project. However, we realized that users could only check the status if we create a report and filtered down based on the user opening the report. However, this does not allow users to view the projects that their colleagues submitted on…
-
Update Request Email Notification - Limit fields to edit
I'm creating an email notification from a project plan to request updates for tasks that are in progress however the form allows editing of all fields on the selected rows of the plan and I only want the recipient to be able to edit one or two of the fields. However, they do need to see all of the fields on that row. Is…
-
Pre-Populate Form with Entire Field from Sheet
Hello Community, I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?…
-
INDEX(MATCH formula issue
I am trying to use helper columns to consolidate form submissions onto the top row of a sheet, in order to use Document Builder to populate a PDF with the inputs from eight different sessions. There are about 10 columns per session. In the screenshot below, the "Which Session" column is a drop-down list with radio buttons…
-
Can I add a table to a form
In a form, I have a text field that a user can fill in with product information. What I was hoping to do within that one field was to have a table, so users can format the information in that response correctly? Please see attached image - what I want to appear is in red. If this is not possible is there a different way to…
-
Multiple workflows in a worksheet - "This workflow was triggered by at least 5 other workflows"
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st…
-
Forms: How to print/generate a PDF with field label and answers
I am creating a survey form, and the questions are quite long. There is a character limit for the column/field name, so I just use numbers (e.g. "question 1", "question 2") in the column/field name and put the actual questions in the field label. That seems to work for the form. However, I want to be able to print/generate…