-
Creating multiple row entries from one submitted web form?
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date…
-
Excluding indented rows from being auto-numbered
I am using a web form for users to intitate developent requests and have set up column to auto-number each job request (P0001, P0002 etc.). The shop supervisor then adds rows below each job request to assign tasks to different team members and indents these under the main job request. Smartsheet assigns each indented row…
-
Can multiple web-forms feed the same row upon submission?
Good Morning, I would like to have two webforms: one for an external user and the other for an internal user to each fill out and submit separately but have all the information from each webform compile and fill into the same row on the master sheet. Is there any way to link the two web-forms so they can feed the same row…
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…
-
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…