-
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?)
-
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…
-
Creating a formula that references a static cell?
Hello, I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest entry. Is there a way to accomplish this? Currently, if a new entry is submitted, the formula changes to tracking row 2…
-
Email automation with attachments?
Hi all- Wondering whether any of you have worked with automations involving sending emails with attachments. I am working on improving our system for issuing travel reimbursements post-conference (we have to use a specific Excel form for now sadly), and we are currently using Smartsheet/Generate Document to generate…