-
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…
-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…
-
Form Submission / Vlookup Integration
Is there a mechanism to achieve either of the following scenarios: Individual populates form and choose a serial # from a drop down list. Can the fields on the form then use vlookup to auto populate the equipment's location from a master grid sheet on the form prior to submission? OR Individual populates form and choose a…
-
Basic Logic in Forms - Not working
Hi all, Im setting up a form, and what should be quite simple doesnt seem to be working for a logic request. I have a question midway through the form, if the user selects the anser 'Yes' from the dropdown (field A), a field appears to answer (Field B). If its a no, then the field stays hidden and move on to the next…
-
Possible work around for update request to apply a logic
Hi is there any work around to customize the update request like main form to put some logic and have a mandatory fields too ? and also is there any possible thing to do about on the attached files on attachment to view it on view only not auto download the file?
-
How can I show different dropdown values to different people in a Smartsheet form?
Hi everyone, I’m setting up a Smartsheet form for my consultants and need some guidance. Each consultant is offered different hotel nights, but I only want them to see the nights that apply to them when they complete the form. For example: Consultant A should only see the options Jan 10 and Jan 11 Consultant B should only…
-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notifications…
-
Form Users Being Required to Sign In
Hello, I have a form that's set so that anyone with the link can use it. However, some users are being required to sign in. Does anyone know what could be causing this?
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Best way to pull data from different columns into one
I have a worksheet that is populated via a form. Worksheet is currently 300+ columns wide (I didn't build it, I inherited it). The form is used by facility management technicians. Each time they go to a client site to service facilities, HVAC units, refrigeration units, etc. they complete this form. Yes, they complete in…