-
How can I ensure a copy of responses goes to a designated person?
I saw a formula that automatically checks the box and auto-populates an email someone else fills out, but how do I make sure it goes to the same person or persons every time? Referenced answer here: https://community.smartsheet.com/discussion/79681/form-autofill-send-me-a-copy-of-my-responses
-
Reset form for registration
I have setup a sheet & form to use for guest registration at events. When someone enters their information and submits the form, it sits at the "Thank you. Your response has been added to my Smartsheet." message. I need the form to reset to a new, clean form for the next person. How do I do that?
-
Auto fill a form ?
I have a sheet that has say 50 questions on it. Some of them I can pull in from another sheet, and I just need to confirm the answer with the client. Is it not possible to display that answer that I pulled in from another sheet when I use the form view instead of the sheet view? The form looks much better , but you can't…
-
Using Forms, I want to include a link to another Smartsheet that is accessible via cellphones
Hello! Employees report their absence using a Smartsheet "Attendance" form, usually from their cellphone. I've created a "picture map" on a separate Smartsheet grid to show new employees the different buildings and managers and linked it to my form (it's pretty confusing with 5 of the buildings on the same street). The…
-
How can I drag a file from Google Drive to a Smartsheet form?
Hi. Is there a way to adding files to a Smartsheet form directly from Google Drive without having to download it to a computer and then uploading it again to the form?
-
Using forms to add data to an existing row
Hello, I can see that a form will populate data into the next available row in Smartsheet. Can forms be used by other Team members to to gather and add info to pre-existing rows, governed by a specific date as an example? Regards, Richie
-
How can I update a row's information using a form?
I have a sheet that identifies each submission by a submission number. If I use that submission number as the "matcher" how can I update the other columns in that submission number row? I created a form but it only adds rows at the top. However, my coworkers will be using this and they won't have access to the sheet so I…
-
Is autofill possible in this scenario? and how
I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this? Thanks
-
Using Automation/Workflow to copy multiple languages form responses into one sheet
Hi, I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish. I have created an automation that filters for a particular school and creates a copy of the row on a…
-
Form columns update other form column
Dear reader, We have developed various forms (per service) to map the use of our services by our customers (Non Smartsheet User). The customer must enter his company name on every form, but this is not desirable if a customer submits all different forms at the same time. Is there a possibility to develop one form where the…
