-
GOOGLE FORM - ERROR
I had my Google form synced with Smartsheet and it has been working well. For no known reason, new form entries from Google no longer enter into Smartsheet. An error occurs when I go into the Google form and try to reconnect. The error is below: What could have caused this error? How can I fix this error without having to…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
-
Formula on data from web form
I'm using a web form for a costume contest to be able to have people sign up. Due to the rules, they must be at least 18 years old to compete. I have a formula to display the person's age based off of the current date, but I want this to auto-populate when they submit from the form. Is there a way to do this?
-
Web Form Linked to Multiple Smartsheets
Hello, I was wondering if it is possible to create a web form that is linked to multiple smartsheets. I am working on a project for a friend. He is doing some research, and wants to know what things people have tried out and have ratings for these (multiple items on the one form with ratings for each, under each item). To…
-
Can web forms update multiple sheets?
I'm wondering if there is a way to create one form that could update fields on more than 1 sheet.
-
Can I customize a Web Form to look like a monthly calendar
We are newer to Smartsheet and still learning some of the features. Each month we ask our Home Care Caregivers to submit their Monthly unavailability, dates and time of day that we cannot put them on the schedule. We currently have 12 unique PDF forms - for each month - that have to be created once a year then emailed and…
-
Webform copy for someone other than the creator
The help center states "there isn't a way to have the web form confirmation email sent to the sheet owner or collaborators," however,the collaborator would like to an email that looks like the form and not a Notification which looks like the sheet. His reasoning is that he wants to print the webform which is vertical and…
-
Webforms for help requests - best practices
We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to…
-
Web Form
Hi there, I was wondering if there is a particular access level where someone can see and/or edit a web form without having access to the data behind the scenes? I'm asking because the person isn't computer savvy and gets overwhelmed easily but would like to be able to edit the webform since it will be used by her to fill…
-
Form and Sheet Functionality - Available security levels for users
Hi, We've created a web form in Smartsheet that users populate and then directly feeds a "master" sheet. From there, we are creating multiple reports off of this sheet for our various departments. Our issue is how to restrict user access to the sheet as we don't want data to accidently be deleted by one of the many users.…
