-
Tie Forms Logic to a Section
Hello, is there a way to tie logic to an entire section - we have a "yes" "no" question, that I would like to have "yes" responders sent to one section, and "no" responders sent to another. I have the logic tied to section headers that proceed those sections, but that doesn't appear to be working. thanks!
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
Automate sending a form
I would like to send out a form to a list of people on a specific schedule (weekly), so that they fill it in, and I collect the responses and report on the information. Can I use the Automation feature for this, or is this something that can be configured in the Form? How do I set up the automation feature to send the form…
-
Form is not working
We have a lot of forms that get used daily, but we are having random problems with this one sheet/form, a couple different things will happen and it is at random: 1) if two forms are uploaded close to one another, only the first one will come in and the second one will not submit and it gets lost. 2) They will upload one…
-
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
