-
2 forms one sheet
Hi all, I have 2 forms connected to one sheet. I would like to trace which form was used for submission. I tried to put in a source field with a default value which is the title of the form, to differentiate the two. However, while it populated the column in the sheet it, does not display the default value chosen that…
-
Allow customers to add rows to a form
Hi, I am creating a form to allow our customers to order new stock. I would like to give them the option to add rows per stock item and have multiple options per row. For example each row on the form would have 4 fields: Item (drop down of all items that can be ordered) Qty in stock (numerical field where the customer can…
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
-
Linking contacts from sheet A to sheet B
I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible? Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset…
-
Forms Updates? ie signatures
Anyone know of any changes coming to forms? I use forms for all kinds of things within my company but I think there are some key features missing. I would be able to use Smartsheet exclusively if the forms could capture signatures. There are many "documents" that require this and it seems like it would be an easy fix.…
-
Adding images to a form that shows up in an easy way to view
Hello, We are planning to have a holiday contest where people will upload photos of Gingerbread houses to be put up to a vote. We plan to have people submit through the form and attach an image. But the image only shows in the attachment on the side. People cannot view it automatically. After all the submissions are in, we…
-
Changing value in cell
Hi All, I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name. For example, I…
-
Auto Fill some form fields from previous form submission
Is there a way to auto-fill some fields in a form from the previous form submission? We use a form to capture actions by Project and Project Manager and would like for the Project and Project Manager information to be captured from the previous form submission, so that only the actions and due dates have to be entered for…
-
Forms fail to submit, ending in unfixable error
Hello All, Students submit information via a form, and several to many have issues where the form cannot be submitted. There is no information missing. Closing the browser and resubmitting almost always works. Could there be something else at play? Timeout?
-
JOIN & CHAR and blank cells
Hi - I am joining cells in a row that may or may not be populated with data. I need to pull them all into a single cell to map to a document. I've managed to pull them all in using this formula: =JOIN([PF Employee Health & Knowledge]@row:[PF NSM Logs]@row, CHAR(1)) The issue happens with mapping. When a cell in the row is…
