-
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…
-
Transferring Workflow Requests
I have a form that was being used to route matter closing requests from the attorney to Accounting to Records. The user in Accounting that the form was going to left and I thought I changed the email on the workflow before she left but it turns out that I had the email incorrect so all of the forms that were submitted in…
-
Automated Workflow in archiving the data in the sheet
We are using the Smartsheet form to collect the real-time customer experience survey data. One of the challenges is, after a few months, the number of rows in the sheet will approach the 20,000 rows limit. Therefore, we need to manually go in and move some of the older data to a new sheet to allow the space for additional…
