-
Include Help Text on Form Submission Copy
My organization currently has a site visit assessment form. Many questions on this form are too long for the sheet column headers, so the columns are just labeled Question 1, Question 2, etc. The actual question is then put in the "Help Text" field on the form. Many leaders who fill out this form opt to receive a copy of…
-
Form - commas with number restricted fields
Add the ability to use commas when entering data into a number restricted field. Even if they are systematically removed when the user completes their entry in that field. Other form tools allow this, which helps users ensure they enter the correct numbers.
-
How to identify the latest record submitted via a form among all entries by the same submitter?
My smartsheet dataset is comprised of form submissions. Businesses are required to submit the form monthly, and I need to assign a "red" color to businesses who have not submitted a form in the last 60 days, and "yellow" to businesses who have not submitted a form in the last 30 days. I do have a separate sheet listing all…
-
Meeting Room Booking System
Hello, Has anyone in the community ever developed a meeting room booking system with Smartsheets? I found an awesome system from Prodactive on YouTube at: But understandably, it doesn't tell you how to create it. From what I can tell it requires a sheet, form, calendar app, dynamic view, and a dashboard to bring it all…
-
Is there a way to automatically capture the Active Directory User Principal Name with a form?
I have a form that is filled out by users who don't have Smartsheet licenses, so they can't log in to Smartsheet. I want it to automatically capture the User Principal Name, which is the ID that the user used when logging on. Is there a way to do that? I have created a "Created by" column, but all it captures is…
-
Can logic be added to a sheet?
My boss wants to create a sheet that includes 4 different profile forms. I'm curious if this is even possible. Basically, we have 4 different excel docs that are profile forms, we want to try to combine these forms on a grid in Smartsheets but we want the fields to auto populate depending on which profile form is selected.…
-
using Smartsheet sheet/dynamic view to pre-populate Smartsheet form
Is there a way to take data value from the sheet/dynamic view and auto create a form from the data? i'm working on a 3rd party invoicing portal and i would like to auto fill the form base on the row that they have access to from dynamic view.
-
How to deselect a radio button answer option in web form?
Is there a way to allow a user the ability to deselect (or unselect) a radio button option after making that selection (i.e., clear out their choice and make no selection after already having made the selection?)
-
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…
-
File Upload Not Showing on Form Through Automation
I was able to create a form and add the file upload option. This is a form that needs to be filled out by over 70 different vendors and I am using automations to send out on a 6 week cadence. When I check the form via Open Form on Smartsheet, the file upload section is showing just fine. However, when the form is sent out…
