-
Form data not loading into sheet correctly
I have created a timesheet and form to go with it. I have several people using the form as a test pilot. Whenever one particular person enters the required information into the form, it loads into the spreadsheet as something else. For example, this person entered today's date (2/29/24) and the amount of straight time…
-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?
-
Form link field validation
Hello, Is there a way to add validation to a hyperlink field on a FORM? I could run a check after submittal, but that is more effort than it is worth. Double Dipping here: I was reading an article on the best online forms. They recommended the error notification be immediate. I have many students baffled by what is wrong…
-
Paginate a long form
Hello community, I'm new to Smartsheet and have a few questions for using the Forms. I have a survey questionnaire with 20 questions. Is there a pagination feature in Smartsheet that lets me break the long form into several pages? It's a common feature in mainstream survey tools like Qualtrics or SurveyMonkey. Is there a…
-
RFQ and Invoice
Hi Team, I am trying to find a template to create/form a RFQ for a customer and then turn that into an invoice. So for clarity - customer ask for a quote to build a product that has multiple steps to complete. for example: Purchase metal, cut metal, shape and form metal, weld metal, pain and ship. Steps and processes might…
-
Perform SOX Documentation Requests
Hello, Is it possible to use the form tool to send requests for documentation? For example, I want to request documentation for a control, I want every field in the form already pre-filled out by the row of information, and I want the recipient to attach documentation based on the request description? It seems like forms…
-
ALL conditional logic not working on Form
None of the conditional logic is working on the form - though when I make a copy of the smartsheet, the copy's form is working as expected? Could there be some sort of default that is assigned when a copy is created? I am suspecting the issues lies in the smartsheet itself - not the form. As the form logic has not been…
-
Is it possible to see how many people have opened a form link?
We have sent out a survey and are trying to see if people are opening the link to the form and are working on getting the information together (it is a lengthy form) or if they are not even looking at it. We don't necessarily need the who has viewed it but just the number of times the link was opened. Is this possible?
-
Tracking Activity on Form Links
It would be helpful to have some tracking on how many people are clicking on links for forms/open the form. We have surveys that are sent out to various partners and it would be helpful to know if the form is being looked at or not. Additional tracking could be on who has opened it (if required to log in to complete) or if…
