-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
-
Can we apply rules to repeat form use?
Hi, I have created a sheet to collate feedback on the completion of projects. I've added a copy of this sheet to each project I have, and then set up automation so that each submission feeds into a Master Sheet for PM's to review. It's a pretty basic sheet with only 5 columns, but I'd like the facility to repeat the…
-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Notification When Forms NOT Completed
I'm trying to set up a notification that goes to a manager each Monday morning informing him which technicians have not completed a vehicle inspection report the previous week. The link to the form is emailed to each technician Monday morning (eg April 15). They open the form, select their vehicle number from a dropdown…
-
New Employee Onboarding - Forms
Hi - I'm using the Employee Onboarding template set. I want to set up a form within the sheet that managers can fill out with the applicable info: Employee Name Manager's Name Start Date Job Title I want these to populate directly into the sheet from the form The challenge is, because these are row and not column entries,…
-
Linking new entries to previous entries - tracking attendance
I'm trying to create an easier/faster way to track attendance at the multi-week classes that our health educators teach. Currently, they have to enter in static information every time they complete our outreach tool (like, address, timing etc) and I am trying to make it so that they only have to enter that information one…
-
Multilingual forms
Hi, I`d like to embed/ insert form to a web page that has multiple languages. Is it possible to create multiple versions of form that will be showed based on the web page language? Or what is best practice in this situation? Thanks for the answer. Best, Beata
-
What size image, width x height, is best for a background logo on a form?
Has anyone discovered the right dimensions for an image to best fill a form background? Is it conditional on form-factor? dm