-
QR code directing to Smartsheet form intermittently not directing to Smartsheet form
I have created a QR code for folks to scan to access a Smartsheet form to complete. Two out of 17 people who scanned the code received this instead of the form to complete.
-
Forms URL query String, IS there a limit to how many queries can be used?
Hi, I am a novice with Smartsheet, but am learning. I have a form that I need to pre-populate so we can send it out to technicians to complete a field report. I can get five fields to populate, but no more than that. ="https://app.smartsheet.com/b/form/d2cda8ab647e4c11b40e503977eb916b?Part%20Number=" + [Part Number]@row +…
-
Is it possible to prepopulate data with the Dynamic view's own form?
When I use the traditional forms, created directly from the grids, I use the feature of prepopulating the data using web strings. I'm currently using Dynamic View, which has an excellent system for navigating through records and even a form for entering data. Is it possible to somehow prepopulate data? I don't think so...…
-
How to use a form to fill in a sheet with pre-determined "Primary Column" fields?
I need to build a form that will fill out the sheet shown below. The "Workstreams" column is a pre-determined list of Workstreams; I just need my customer to be able to provide the info in the rest of the columns for each of those Workstreams. I am hoping there is a way to do this without having to duplicate the columns…
-
Print a Smartsheet form- to MS Word and PDF
It would be nice to have the ability to print a Smartsheet form created to MS Word and PDF (form view layout, not smartsheet view layout) after someone has submitted the form.
-
Can you add an email address via the Link option in a header field on a form?
I want to add verbiage, a name and email address in a header field at the top of my form. I enter the email address, highlight it and click the link option and it's pasted in there. It shows underlined but when I preview the form and click the link, it takes me to my company page (for example, cbre.com and not my email…
-
Looking for VLOOKUP formula to pull data from mulitple sheets
Hi all! I am attempting to use a VLOOKUP formula to pull data across multiple sheets. Since Smartsheet does not have the capability (yet, I hope!) to merge multiple form submissions onto one row, I am creating 2 other data collection sheets and need to pull that data to my master sheet. Each sheet has a unique reference…
-
URL Query String and Workapps
Hi, I created URL query string to pre-populate values a form for 12 different departments (to ensure each selects their correct area). I followed the instructions from Use a URL query string to prefill different default values for the same form | Smartsheet Learning Center. Then I tested each URL strings to ensure the…
-
Form Naming Conventions
Similarly, to how we can use the {{}} brackets to enhance the subject line of an automation, being able to include this in naming forms would save a lot of headache and manual effort. Currently, we have to manually rename each form as sheets are created to match their project naming conventions. If we could use the bracket…
-
Contact List Field in the New Logical Forms
I have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the contact field nothing is populating from my imported contact list, what am I missing?
