-
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…
-
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
-
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…
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
Can I set-up a form to Accept electronic payment?
I have an event where vendors can reserve space at our convention. I would like them to fill out the form electronically using Smartsheet. Is there a way to have them pay for the same from the form?
-
Form Not Accessible
Hi everyone - We have a form that has been in circulation for about 2 months that has randomly stopped allowing access to unlicensed users. I don't see anything where it is restricted. Has anyone else encountered this and resolved the issue? Thanks!
-
Confirm When User Attempts to Leave or Close Form Without Submitting
It's great that forms notify the user when they attempt to submit and haven't filled in all required fields. Unfortunately, I've found some distracted users are still not realizing their data hasn't been submitted and are browsing away or closing the form. I've seen some sites ask for confirmation when browsing away or…