-
Phone number validation won't allow all zeros
Hi- We have been using a SmartSheet Form for a while, and users have been able to enter 000-000-0000 if they don't know a person's phone number. However, over the past few days, it appears that the phone number validation field will not allow all zeros any more. Is there a way that I can change this? We would like the…
-
Add Custom, Pre-Set List of Update Request Dates
Smartsheet does not allow users to enter a list of unique dates for an Update Request to be sent out. The closest users can get to this feature is setting the Update Request to be sent on a certain day and time, however, this allows the user to enter only one date for one request (or a repeated sequence like daily, weekly,…
-
Force refresh of page if User uses back button on Browser
I would like to find out how I can force a page refresh if a user press the back arro / button on their browser
-
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: 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…
-
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…