-
SmartSheet Form and Auto-Number Field as an option
Is it possible to create a SmartSheet Form, and utilize the Auto-Number Field (created already in a sheet) as an option to take advantage of the conditional logic? Example: 1) Open form 2) Enter Auto-number 12345 (from existing sheet entries) 3) Once selected, conditional log would display next field (if already filled…
-
Require a number format
Is there a way to force input in a form to be in a specific number format? For example, require that a customer number be 10 digits, or an account number be XXXXXX-XXX?
-
URL Query String - most recent entry
Hi - is there a way to use URL query string to pre-populate a form field with the most recent entry? The use case is as follows: Forms used to log vehicle maintenance; I would like the "Starting Odometer" field pre-populated with the most recently entered "Ending Odometer". Any suggestions? Thank you!
-
Multi-lingual functionality
Is there a way to have system messages appear in English on one form and French on another form-driven from the same sheet. The only way to change the prompts so far is to change my personal settings which impacts all sheets.
-
Roll up based on selection from one column and count of answers across mulitple columns
I created a form to get feedback from 6 different business units regarding 48 different applications. The participants select their business unit name from a single select dropdown. They then rank each application as “Not Used By Myself or My Team”, “I'm Not Sure”, “Not Important”, “A Little Important”, “Somewhat…
-
Ability to Populate Fields with Needed Data Based on Conditional Logic in Forms
In creating a form the other day, I came across an instance where it would be extremely useful when a user selects an item in the source field via a dropdown selection, it not only shows the needed fields for that specific item, but it also pre-populates the correct information that would also be stored in the target…
-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
-
Is there a way to make the form link clickable in google chat notifications from Smartsheet?
Right now, when I send a reminder to fill out a form with the link, it is not clickable (the smartsheet app is, and the email notification is), but, this is odd as for a while I only had my G-chat notifications on for receiving smartsheet updates/notifications, but had to turn on my emails again in order to receive the…
-
Create a Unique Form within Template
Is there a way to link a form within a template that will be associated with the NEW document created by using the template? CONTEXT: Template Purpose: each time site is visited by senior team, a template is created for site visit to document walk-through notes. Form Purpose: individual senior team members would click the…
-
Form Usable on a Template
Would be great if there was a way to create a Form that is linked within a template that when template is used, creates a unique Form so that it translates over to the newly generated document from the template! Otherwise, the form is still stuck linked to the original template and cannot be used on the new document :(