-
Forms: Telephone Number Validation - number of digits required
Currently unable to use telephone no. validation for Forms, as the validation requires Form users to enter a 10-digit number for New Zealand - standard mobile numbers in NZ differ between 9 and 10 digits. It would be great if the data validation could be updated to allow for phone numbers that are different to the default…
-
Editing rows using forms or some other android UI
I'm a freelancer, and I want to use smartsheet to schedule jobs and do basic accounting. I have a 'new job' form to create a row with customer and job info. I need a way to then add more data to that same row later, once the job is completed (total price, material cost, etc). Is there a way to do this with a…
-
Forms are forcing outside users to login or download app
Hi! Our team uses smartsheet to organize requests for support and to organize our data around the requests and the support that our team provides. We have several forms that individuals use to request services, complete a self assessment, and agree the terms of our services. Most of the forms we use work as intended,…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
-
Use Emails in Text/Number field in an Automation?
On a form, I have a field set to "Text/Number" as the "Field Type" with "Validation" → "Email" selected for that field. However, it seems I cannot then create an Automation that picks up that field/column as the contact for an automated workflow. Am I doing something wrong? If not, is there any work around to this?
-
Sheet fields missing from form creation.
I have an index doc sheet with 4 columns of information to pull in onto a master sheet. I then have other fields on the master sheet which I need filled out by using a form. When I go to the form creation, it only lists 1 of my fields from the index doc sheet and master sheet to select for the form. Why is that and why…
-
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
-
How to Highlight Duplicates in submit new hold Smartsheet (Identify Duplicates)
Hello,,,, I want to add a feature to Smartsheet, when a team member uploads an order in the smartsheet through the (Submit New Hold Items form) , if the order has already been uploaded previously, a legend should appear indicating this so that the order is not duplicated.
-
Send Forms via SMS
Would like to see a feature where we could send forms (or link to forms) via text messaging or SMS. Would like to send the form via SMS to the customer so they can fill out the form. Also, would like the clean looking PDF form created by the form submission to be auto sent back to the customer, instead of the Smartsheet…