-
How to create unique identifier if you have multiple forms that should fill on the same line?
I am attempting to attach 3 forms to a workflow. One form is an intake form done by an internal team. The second and third forms are done by to different third parties. Ideally, all of the forms would fill in on the same line in my smartsheet. I know an unique identifier would be ideal to connect these, but the reference…
-
How to automatically attach form-submitted file attachments to the sheet, rather than a row?
The sole purpose of the form is to enable an individual to quickly upload a file attachment to a Smartsheet grid. However, when the files are uploaded to the grid via the form, they are always attached to a row, instead of the entire sheet. Is it possible to disable row attachments, or make sheet attachments the default?…
-
Automation - Copy row to current sheet
I have a user-oriented form associated with a sheet. The sheet works as it should, but we have a specific workflow in our business where a user may need to immediately enter a nearly-identical form immediately after submitting the first form. The form has dozens of fields and the second submission is identical in all but…
-
Editing rows with a form is the #1 tool missing here
I know this is not a new topic, there are many questions and discussions on this already. But me and my end users really need a form view for modifying existing rows. My rows contain over 250 columns in the database I'm building. If I could create different form views to modify rows with, my efficiency would probably…
-
How do I make a form properly link to an image on a dashboard?
I have a created the form and linked it to several photos on the dashboard but when I click on the photo, instead of the poll view popping up - the backend summary sheet pops up. The goal is to have employees click on the item they would like and then fill out the survey that asks them their size.
-
How to Pre-Populate a Field in a Form?
Hello Smartsheet Community, I am trying to pre-populate my Work Order ID field in a form with the number it is assigned in its row. A while back, we were given a complex formula to include specific fields but it is very complex and hard to understand. Can someone please let me know how to add the Work Order ID to the form…
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Generate Bar Code and link to cells
can we generate barcodes of each equipment and with the help of bar code scanner, can it display the information of it with the the options to update the forms? I know we can update the forms but how can we display the informations from the sheet at the same time?
-
How do you add an email address in a form?
How do I add a hyperlink to an Outlook email address to the description section of a Form? I have tried 'mailto:example@xxxxx.com' but the hyperlink function automatically adds 'http://' in front of the link, leading to a blank page.
-
Reply to a form via email.
After filling out a form, you have an option at the bottom of the form to email a copy of this to yourself. Once receiving the email copy, are you able to reply to that email and have the response become a comment in that line on smartsheet? I know you can reply to emails on smartsheet and have the response become a…
