-
Is it possible to fill out data for several rows with different info using a form?
My team need to enter several rows of data at once where all but 3 of the columns have different entries. For example: Columns 1 -5 are the same for each row but Columns 6-8 are different Is there a way of saving time by having to submit data for Columns 1-5 once and then on the next rows only submitting data for columns…
-
Formulas not copying to next rows
We have had some issues where the formula is not calculating on a new row when a new form is submitted. The only thing I can see in the activity history is that the new form row came in at 10:24:42 and the row above the new one was being worked by a staff member at 10:24:45. Has anyone seen where formulas stop working if…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
Merge data from Smartsheet in Microsoft Word Document
Hello, I have been able to merge data from a smartsheet into a Google Doc Template using the smartsheet merge add-on. Works great. But, is it also possible to do the same thing but then in a Microsoft Word Document ? I have been asked that question by Microsoft users. Thank you for your help, Rudy
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Using forms in mobile/app
Hi Everyone, We have a form which is filled by the site team. In one field, they have to update the remarks. It is a multiline textbox. But while updating it via mobile/app, there is no option of using 'enter' key to change the paragraph. Are we missing something or is it designed that way. Thank You!
-
Question on How to Integrate a Form
We have a sheet that tracks our inventory. We want to build a form for people to input a pickup request of certain inventory items to be moved between places. Is it possible for the Form to reference the Inventory sheet to see if the Quantity requested for pickup is available? For example The form would ask for an item…
-
Form Resubmissions
Good evening, I'm posting again in the hopes that someone can help me with an issue. I have a form that is being used to route matter closing requests from the attorney to Accounting to Records. I have a number of forms that were submitted (entries in the SmartSheet) but never went to anyone in Accounting because the email…
-
Automatically adding rows to sheet and automatically nesting them under parent row?
Is it possible to have a rows automatically added to a sheet (for instance from a form on another sheet), and have the rows automatically be nested under the correct parent row on the target sheet? For example, if the Primary column is "project name", and "parent project name" is a field on the form, is there any way for…
-
Use a sign up cap within forms
Hi, New to to community and couldn't find the thing I am looking for, hopefully someone is able to help. I am trying to gather sign ups for different events in one sheet using forms. The events got different sign up caps (max attendees). After an event is fully booked and reached it's cap people shouldn't be able to sign…
