-
Anyone else have this issue with forms and know how to resolve?
I am having a problem with forms submitting into a SmartSheet. I've built a simple SmartSheet with some IF commands that apply a score based on dropdown menu answers. I also created a report that shows a selection of columns based on a field being populated. When I submit a form built from the simple Smartsheet, nothing…
-
Ability to Copy Forms
I would like to have an option to copy the form to be able to edit the copied form without impacting the format of the original document. I recently spent three to four hours to create a form. I needed to duplicate the created form to edit and create a new form with some edits. I was unable to do so.
-
What is the simplest way to have data from a form be pulled monthly into reports/dashboard
I have created a smartsheet form to log information on service intakes. I have then created sheet summaries and reports with a bunch of information (age, demographic, reason for call, type of service requested etc.). From this I created a dashboard showing key metrics and graphs of my data. My challenge is now I would like…
-
Form field for calculating questions
Hi, brand new to SmartSheet! I tried to search for help on my question only finding some posts that were similar but not exact. I created a form, following the BARC 10 assessment which I've attached, that we can easily and quickly have individuals complete and submit via a tablet rather than hardcopy. It would be great if…
-
Creating a formula that references a static cell?
Hello, I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest entry. Is there a way to accomplish this? Currently, if a new entry is submitted, the formula changes to tracking row 2…
-
Why is the QR Code asking me to log into Smartsheet to complete a form?
I have created surveys that associates can scan on their mobile device after each class but the QR code no longer links them to the form. When scanned with a mobile device the associate is asked to either download the Smartsheet app or log into their account. None of the associates have a Smartsheet account and should not…
-
Hide Email Address on Webform using Contact List
I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted, I do not want to publish the email address along with it. Thank you
-
Include Help Text on Form Submission Copy
My organization currently has a site visit assessment form. Many questions on this form are too long for the sheet column headers, so the columns are just labeled Question 1, Question 2, etc. The actual question is then put in the "Help Text" field on the form. Many leaders who fill out this form opt to receive a copy of…
-
Form Submissions aren't appearing on the sheet!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
-
Barcodes scanned into a webform not converting to a number automatically in the sheet!?
Hoping someone can help with this promptly as I haven't got an answer from my support ticket from the 19th. We have a grocery store and the floor team scan the barcode of the stock coming into the store into a form and select the qty and expiry date. This goes to a landing page which has a formula in several columns to…