-
Automatically Send Responses on Form
Hi, I have a Form that a variety of Managers use to input data. Is there a way to automatically send their responses on the Form to them after? Or do they constantly have to check the "send me a copy of responses" button each time they submit something? I tried to setup an automation for it, but I am not sure how I would…
-
Dropdown list with numbers
Hello, I created some sheet that is filled by other users by form. Form is based os single select dropdown list, like this one below: After submitting a form, there are some calculations made on those numbers. Until yesterday numbers appeard in that format: Now they appear in that format, so calculations cannot be made:…
-
Form completion checking box in sheet
Hi! I am attempting to have a box checked on a sheet after a linked form is completed. I have a established columns with a persons Name and want to have a column that has a check box when a specific form is completed by that person. However, the wall I am running into is that I a m having a duplicate row of information…
-
Is there a way to RECONNECT a form field to a column in the sheet? Feature Request?
So here's the scenario: You build a form and it creates the sheet automatically. Then, for some reason, you accidentally delete a column in the sheet. The form field still exists, but the column is gone. You recreate that column exactly like it was in the sheet, however, now the two are no longer connected. It'd be great…
-
Word Count Limitations?
I am setting up a form but need to limit the word count. I already built a formula in the sheets with formatting to identify when an entry has surpassed the 1,500 word count max but I want to limit it while someone is filling out the form so that I don't have to send it back for edits. Is there a way to limit the word…
-
How can I change dropdown values from text to number in forms
I have dropdown values as numbers like below However when the form is submitted, they look like text When i manually change them from gridview, they are in number format
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
How to Auto-populate form with Request Number
Hello, I am creating a form for customer's to input data into our sheet. This form currently asks for "FER Number" which the customer is currently requested to input. However, I'd like to make this "FER Number" auto-generated/auto-populated. I'd like the form to reference the last input "FER Number" on Smartsheet (bottom…
-
Can I have 2 users fill out the same form?
Hello, Is it possible to have user #1 fill out the required fields of a form and submit it, and then have user #2 view the same form with the answers submitted by user #1, and fill in any optional fields? I am looking to streamline a process so that it creates one entry in my sheet, rather than have each user fill out the…
-
Locking some users from editing a form
Is it possible to prevent someone from editing a form after they fill it out? I want certain users to not be able to change their form responses after submission. Thank you, Maya
