-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?
-
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…
-
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…
-
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…