-
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…
-
Can forms return the label and help text in email to person entering the form?
I have a created a desk assessment and in the form provided some assistance options to better the evaluation. Example … Question is longer than the column header so I've put it in the Label as this … Is the Keyboard separate from the screen? Response options are Yes / No / N/A, but in the Help text - I've added Further…
-
How to add additional information after a form is submitted?
We use forms to create project requests, and we know each form is submitted and creates a new row in the underlying sheet. We have 6 unique forms tied to one "project type" sheet (x3 project types). The forms are super intricate and logical, and the sheet has a ton of automations and workflows to it. Our executives want to…
-
Capabilities of Global Updates
Could we use Global Updates the make the following changes to blueprint sheets: Add shared filters to the sheets Add Forms to the sheets Also, can we provision a blueprint sheet including shared filters and/or its own form (not from specific link)?