-
Can you make Form logic more advanced?
I really love the logic in the form but IMHO is not optimal & describe with screenshots my problem also here. I created a form with 7 question and based on the answer either another question gets visible or there is a message a message in RED. If someone manages to get to the 7th question depending on the answer he can get…
-
Logic in Forms - not optimal
Dear Community, I have a problem with the Form we used a lot of logic so if the person choses proper answer another question is shown. If the question is not optimal there is message in red shown (using header). So if someone clicks all proper answers he is shown with the last question and based on it there are 3 messages…
-
Create a form from Smartsheet data
Here is an odd idea that we want to determine if it will work with Smartsheet. Our associates should be able to fill out a form and send it back to our offices, where it will immediately update in Smartsheet according to the entered categories. We are hoping we can then pull this information by monthly update to present on…
-
is it possible to create a search form to query existing data in a sheet?
I have a smartsheet with customer data and I don't want the users accessing the sheet directly. Is it possible to create a form where the user enters a customer id number and the form populates with the customer information from the smartsheet row containing that information.
-
'Save' button for work in progress, for external form-fillers?
We use Smartsheet forms for grant applicants to submit initial information. Without a 'save' button or feature, we've had to advise our applicants to prepare all their answers offline, and then enter all their responses in one session. This can be problematic if the applicant gets pulled away on another task, call, e-mail,…
-
Auto-populate emails on a "contact list" column
I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns ("Requestor Name") is in the Form where they type in their names. The "Requestor Name" column is a Contac List column. My issue here is, how can I have Smartsheet…
-
Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
-
I'm the owner of a number of sheets and used to be able to email forms, but can no longer do so.
I have been able to create a number of forms and I used to be able to send email notifications to people to complete them. However, I can no longer seem to send the emails although I can share a link. We are on a business subscription and I'm the owner of these sheets.
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
Use form to populate an existing row?
I have a sheet that is being used to track data and requires comments from other people. Is it possible to use Form to collect these comments and have them populate into designated rows on the sheet (instead of creating new rows with each new response)?