-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
Can Smartsheet Forms handle more than 100 questions?
Has anyone here made a form that had more than 100 questions, many of them with logic? I know there are limits to logic conditions and before I do a lot of work to build a form I want to make sure Smartsheet is strong enough to handle it. My other option is jotform. Thank you!
-
Multi-Select Form Enhancements
Hi Community, I’m pleased to tell you about two enhancements for forms that a number of you have requested. First, you can now display your multi-select dropdown lists as checkboxes. This is a great way to help respondents fill in those fields faster (You can still display multi-select lists as dropdowns if you prefer).…
-
Dynamic View Form Disappears After Creating New Entry & logic does not run as quickly
Background: We use Dynamic View to allow 3rd party vendors to enter data into our system. The initial form has about 25 fields, and built in logic to show or hide additional fields based on the initial values once the form is saved. On the backend, the Access List column identified to control access to the Dynamic View…
-
Can a Smartsheet Form Show information from a sheet?
Hello! I am very new to smartsheet and am trying to learn. My first project on smartsheet for my team is to develop a form that employees will use to check out and then back in an item while at work. I've got the Check Out part done and have it feed to a sheet so that supervisors can monitor who has what. However, I don't…
-
Using smartsheet logic step in forms - new row created in backend sheet?
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sheet as extra columns. Is it possible for the info to be separated into two different rows rather? We would like the basic…
-
Old entries to the top?
Hi all, I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, how can I re-arrange these old entries? Thanks.
-
Linking forms in a dashboard.
Hi, Currently when one wishes to link a form in a dashboard (not display a form, i mean hyperlink! but guess it would apply to forms in a dash too) You would need to get the url first of the sheet where the form derives from. Instead, it would be handy that when adding a hotlink, it would pop-up when 'Smartsheet item' is…
-
Dropdown options limited to certain people
Hello, Quick question. So i have a drop down menu with 6 options. Is it possible to have on the form where if someone is selecting a option they, depending on who they are, can only see options 1-3? So it would only be a select group of people and the option choice may very. So person 1 can see 1-3 while person 2 can see…
-
How do I automate a Form?
I have a form in smartsheet that some of our Attendings will be using to fill out required shift information for payment processing. I know that on the base sheet I can set up an automation to request an update weekly which is what I need, but does that apply to the sheet the form info transfers to once submitted? Or will…