-
Send Form for Completion to Individuals with Pre-Populated Fields taken from Data in the Sheet
I have a sheet called 'Farmer Access Survey' which will contain the current data we hold on record for 130 farmers. I have created a form, which I want to send to each farmer to confirm the current data we hold, and collect additional information from them. Can I send a link to the Form to each individual in an Outlook…
-
Multiple users Forms - Conditional Logic not functioning
Hello, I created a form that is filled out by 3 parties. The user that initiates the form fills out the first portion than it gets to the second user that assigns the form to the third user that completes the last part. Everyone gets notification so the process works perfect from this point of view. The issues is that the…
-
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…
