-
Send only Columns in row with data when sending Notification
Any way to, when sending notifications on a row being added or edited, omit columns that have no data? Say I had an order form with 100+ possible items on it. I don't want to send a 5 page email detailing all the items the person did and didn't order, I want to have the notification only include the handful of items the…
-
Forms on the android mobile app - text fields have no 'enter' option?
We are using forms to collect data, including addresses within text/number fields. Users are saying that they are having to put whole addresses on one line as they have no option on their phones to hit 'enter' and drop down to the next line. I have tested this on the PC app and have had it tested on Iphones and it works…
-
Daily Automated Report
I am a dead beginner with SmartSheets and I am self taught thus far so explain to me like I've never seen a computer before :) Our hospital holds daily huddles where each department reports out on questions specific to their unit (current paper form attached). I’ve created a sheet that includes all the questions to be…
-
Based upon the answer to a question on a form, can I direct to another form?
If I have a form and the 1st question has 3 options, can I use the logic to direct to 3 other forms so that the questions are relevant to the answer selected? For example, question 1 has 3 answers, A, B, C. If they pick A, they are directed to smartsheet form A, if they answer B, they are directed to smartsheet form B and…
-
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…